How can you tell the difference between an index and a view?

0 Answers  

---

Why we use stored procedure instead of query?

0 Answers  

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

---

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

---

---

What is difference between nchar and nvarchar?

0 Answers  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

What is pragma in pl sql?

0 Answers  

---

What is flag in sql?

0 Answers  

---

Explain the select statement in sql?

0 Answers  

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

0 Answers  

---