Answer Posted / venky

when we fire this query on

first it will send to sql buffer
then sql buffer send to SGA

sGA send to sql*plus layer

this layer interact with the database server if the table
is exist in the database server , it will dispatch the all
rows to sql*plus layer
from this layer to SGA-----> output buffer
..
finally it wii display on the location of interface(screen)

Is it possible to pass parameters to triggers?

1103

---

What is a composite primary key?

1093

---

How to write pl sql program in mysql command prompt?

1096

---

How can you save or place your msg in a table?

1001

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

---

What language is oracle sql developer?

1017

---

What is the order of sql select?

1041

---

What is not in sql?

947

---

what is single byte over head in oracle..?

2401

---

What are sql indexes?

999

---

What pl/sql package consists of?

1081

---

What is record data type?

916

---

Why do we need a foreign key?

1094

---

Which join condition can be specified using on clause?

952

---

What is data type in database?

992

---