Answer / Mohd Kasif

"SQLCODE and SQLERRM are used in PL/SQL to handle errors. SQLCODE returns the numeric value of an error, while SQLERRM returns the corresponding error message."

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

---

What are inbuilt functions in sql?

1 Answers  

---

what happens if null values are involved in expressions? : Sql dba

1 Answers  

---

Is sql a case sensitive language?

1 Answers  

---

What is query optimization in sql?

1 Answers  

---

What is cursor in pl sql?

1 Answers  

---

How to find string or key value using pl/sql code?

2 Answers   Ramco,

---

What is forward declaration in pl sql?

1 Answers  

---

What are actual parameters and formal parameters?

1 Answers  

---

there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?

7 Answers   Cognizant,

---

Is pl sql better than sql?

1 Answers  

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---