Answer Posted / s. elaiyaraja

The Main difference between stored procedure and Function
is SP's can return the value or not, but Functions should
return the value.

And We can use the function within the Queries, but sp's we
won't able to use it in the queries.

We can implicitely execute the sp's. But function's we
can't.

Write a trigger example in oracle?

1053

---

what are actual and formal parameters?

1104

---

What is ASM (Automatic Storage Management) in Oracle?

1189

---

How a tablespace is related to data files?

1107

---

How to do clean up if create database failed?

1026

---

Is oracle an open source?

1073

---

Explain overloading. Can functions be overloaded?

980

---

How do you find current date and time in oracle?

1045

---

How to view all columns in an existing table?

932

---

Difference between cartesian join and cross join?

1032

---

How to load a large xml file?

1050

---

How will you write a query to get a 5th rank student from a table student_report?

1859

---

What are the components of logical database structure in oracle database?

1086

---

How to pass parameters to procedures in oracle?

1040

---

Explain what are the different type of segments?

959

---