Answer Posted / quesanswer

1. Functions must return a value(scalar,inline table or
multi statement table) whereas stored proc may or may not
retun a value.
2.Functions can return a table whereas stored procs can
create a table but can't return table.
3. Stored procs can be called independently using exec
keyword whereas function are called using select statements.
4. Stored procs can be used to change server
configuration(in terms of security-i.e. setting granular
permissions of user rights) whereas function can't be used
for this
5. XML and output parameters can't be passed to functions
whereas it can be with sp's.
6.transaction related statement can be handled in sp whereas
it can't be in function.
7. stored procedures can call a funtion or another sstored
proc similarly a function can call another function and a
stored proc.The catch with function is that no user defined
stored proc can be called.Only extended/system defined procs
can be called.

What is a lookup table in oracle?

973

---

Is it possible to split the print reviewer into more than one region ?

2280

---

What is Reduced List of Values?

2167

---

What is meant by joins?

1062

---

What is the difference between a user and a schema in oracle?

1034

---

Can we call procedure inside function in oracle?

1097

---

How do I find the database name in oracle?

1039

---

What is an oracle user role?

984

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1912

---

How can you merge two tables in oracle?

1001

---

How would you change old and new values in an insert, delete and update triggers?

1022

---

How do I manually uninstall oracle client?

1089

---

Explain how you would restore a database using RMAN to Point in Time?

2146

---

What are the most common interview questions on ETL Testing for experience?

1144

---

How to pass a parameter to a cursor in oracle?

1184

---