Answer Posted / swapnareddy

Declaration Block(optional)
Begin
Executable Block
exception Block(optional)
end;

What is sql and explain its components?

1043

---

How do I view tables in mysql?

955

---

Can you selectively load only those records that you need? : aql loader

1023

---

what are the different functions in sorting an array? : Sql dba

1000

---

What is rowid in sql?

958

---

Why function is used in sql?

923

---

Why do we create stored procedures & functions in pl/sql and how are they different?

923

---

Can you inner join the same table?

975

---

Is left join faster than inner join?

1103

---

what are all types of user defined functions? : Sql dba

1029

---

what is a table in a database ? : Sql dba

1023

---

What is full join in sql?

972

---

define sql insert statement ? : Sql dba

1009

---

Cite the differences between execution of triggers and stored procedures?

1071

---

What is java sql package?

1072

---