Answer Posted / sudhir kumar singh

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

)
exec procedure_name(first_parameter,second_parameter);

What are different categories of sql commands?

1195

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2270

---

What is forward declaration in pl sql?

1141

---

Define commit, rollback and savepoint?

1081

---

What are predefined functions in sql?

1107

---

Name the different types of indexes in sql and define them.

1222

---

Explain exception handling in pl/sql?

1082

---

What is the difference between sql and mysql?

1178

---

What do you mean by stored procedures?

1069

---

How can use stored procedures in sql?

1191

---

Why self join is used in sql?

1031

---

how to convert character strings to dates? : Sql dba

1098

---

What does 0 mean in sql?

1020

---

What do you understand by case manipulation functions?

1079

---

what is offset-fetch filter in tsql? : Transact sql

998

---