Answer Posted / sudhir kumar singh

procedure_name(a in number,b out varchar)
(
script of execution;

)
exec procedure_name(first_parameter,second_parameter);

What is sql and how does it work?

1087

---

What is the most restrictive isolation level? : Transact sql

1024

---

What is rank () in sql?

882

---

What do you mean by stored procedures? How do we use it?

929

---

What is output spooling in sql*plus?

983

---

What are character functions?

1040

---

What will you get by the cursor attribute sql%notfound?

1012

---

is it possible to pass an object or table to a procedure as an argument?

1059

---

What are local and global variables and their differences?

1045

---

What is group by in sql?

1025

---

What is fmtonly in sql?

1008

---

Is delete faster than truncate?

957

---

What is the syntax and use of the coalesce function?

1097

---

Explain clause in sql?

959

---

What are all ddl commands?

1014

---