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 privilege is needed for a user to insert rows to tables in another schema?

1010

---

How to rename an index?

1063

---

Give the advantages and disadvantages of clusters.

1048

---

How do I spool to a csv formatted file using sqlplus?

1022

---

Can we store pictures in the database and if so, how it can be done?

1026

---

Respected sir, Please send me technical questions related to oracle apps..

1808

---

How is it different from a normal table?

1023

---

Can we protect our pl/sql source code?

1038

---

Describe varray?

1052

---

Explain oracle’s server parameter file.

983

---

Is a rollback possible to any savepoint?

1091

---

what is the difference between functional dependecy and multilevel dependency?

2454

---

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2118

---

Explain the difference between replace() and translate() functions in oracle?

1026

---

Will you be able to store pictures in the database?

1112

---