Answer Posted / vijay_1994

declare
cursor
user defined exception
variable
begin
sql statement
plsql statement (application wise/business logic)
exception
end;

How bulk collect improves performance?

984

---

tell me about various levels of constraint. : Sql dba

1025

---

Can a composite key be null?

959

---

which tcp/ip port does sql server run on? : Sql dba

1002

---

How to use sql statements in pl/sql?

1095

---

What trigger means?

962

---

What is execute immediate?

1065

---

What is sap sql?

958

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3998

---

how to rename an existing table in mysql? : Sql dba

1044

---

how can we know the count/number of elements of an array? : Sql dba

1043

---

What is pl sql record in oracle?

1010

---

What are the benefits of stored procedures?

1046

---

How to pipe multiline string to isql?

998

---

What is cursor status?

1175

---