Answer Posted / hemanth

1) functions are used for computations where as procedures
can be used for performing business logic

2) functions MUST return a value, procedures need not be.

3) you can have DML(insert, update, delete) statements in a
function. But, you cannot call such a function in a SQL query..
eg: suppose, if u have a function that is updating a table..
you can't call that function in any sql query.
- select myFunction(field) from sometable;
will throw error.
4)We can call a function from a procedure, but it is not
possible to call a procedure from a function

How can windows applications connect to oracle servers?

982

---

How to put more than 1000 values into an oracle in clause?

970

---

Can we create trigger on materialized view in oracle?

938

---

Difference between open_form and call_form in oracle.

1092

---

Explain database link?

1059

---

what are bitmap indexes? How does they work?

2181

---

Explain a synonym?

969

---

How to delete an existing row from a table in oracle?

1014

---

Explain oracle instance.

1105

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2144

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2654

---

How to login to the server without an instance?

1103

---

What to do if the binary spfile is wrong for the default instance?

998

---

How to create a table in a specific tablespace?

912

---

Which environment variables are absolutely critical in order to run the OUI?

2068

---