Answer Posted / ankush

Function always return a value. procedure may or may be not.
IN a select statement function may be called but we should
execute the procedure.

We can call a stored function from dml statement.

Here is simple example


CREATE OR REPLACE FUNCTION TEST_1 RETURN NUMBER IS

BEGIN

RETURN(10);

END;


SELECT TEST_1 FROM DUAL;


update emp

set sal = sal+ sal*test_1();


To be called from an sql statement a function should follow
the following purity rules.
1) When called from a SELECT statement , the function
should not modify database objects.
2) When called from INSERT , UPDATE, DELETE statements ,
the function can not query or modify the tables that was
modified by the statement.
3)When called from SELECT , DELETE, UPDATE, INSERT
Statements , a function should not contain TCL, DDL
commands.

What is the purpose of a sql?

913

---

Explain what is a column in a table?

1041

---

How to use sql*plus built-in timers?

1094

---

Is and as keyword in pl sql?

904

---

Does view contain data?

983

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1130

---

What is restrict in sql?

1031

---

what is sub-query? : Transact sql

1039

---

Define commit?

940

---

What is query syntax?

912

---

what is a composite primary key ? : Sql dba

997

---

What are three advantages to using sql?

958

---

Explain spool.

1111

---

How do I make my sql query run faster?

891

---

What is sql scripting?

1034

---