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.

How to apply filtering criteria at group level in oracle?

1084

---

Point the difference between translate and replace?

1145

---

How to use subqueries with the in operator using oracle?

1134

---

How to update values in a table in oracle?

1075

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1977

---

what is the difference between functional dependecy and multilevel dependency?

2514

---

How to create a stored procedure in oracle?

1147

---

What is oracle rowcount?

1143

---

What is oracle open database communication (odbc)?

1077

---

How to set a transaction to be read only in oracle?

1135

---

Explain alias?

1187

---

What is the database name in oracle?

1072

---

What is a read write transaction in oracle?

1126

---

what is the use of system.effective.date variable in oracle?

1160

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2365

---