Answer Posted / roopesh kumar

Diff. B/W Procudure & Func......
(1) Proc. may or may not return value or more than one.
but func. must return a single value.
(2) We can call a func. in a select stmt. but func. should
only with IN parameter.
But we can't call a procedure inside a selct stmt.
because calling a procedure itself a PL/SQL block.

There is no too much diff. b/w proc. & func. but the thing
is that when we are looking to get back a single value we
should use func. in case of more than one then we should go
for proc.

Diff. b/w proc. & trigger..

(1) We have to call a proc. explicitly but trigger will
fire implicitly with assosiated event.

what is unique key constraint? : Sql dba

1094

---

What is t-sql? : Transact sql

1039

---

Can a view be mutating? If yes, then how?

1086

---

What is a data definition language?

1195

---

Is there any restriction on the use of union in embedded sql?

1197

---

what is self-join? : Sql dba

1236

---

What is sql*loader and what is it used for?

1216

---

What is sql procedures and functions?

1071

---

What has stored procedures in sql?

1098

---

Write a sql query to get the third highest salary of an employee from employee_table?

1116

---

What is trigger in pl sql with examples?

1080

---

How do I create a memory optimized filegroup?

1011

---

Can a procedure in a package be overloaded?

1099

---

Can you have more than one trigger on a table?

1045

---

what are the nonstandard string types? : Sql dba

1204

---