What is difference between sql function and stored procedure?

0 Answers  

---

What is the most important ddl statements in sql are?

0 Answers  

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  

---

Why do we use procedures in pl sql?

0 Answers  

---

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

What is before trigger?

0 Answers  

---

How do I copy a table in sql?

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,

---

What is nvl?

0 Answers  

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---