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.

Explain unique key in sql.

1056

---

Do prepared statements prevent sql injection?

992

---

Why is sql*loader direct path so fast?

1138

---

What is minus?

1050

---

What is on delete set null?

1132

---

What does (*) mean in sql?

994

---

What is the purpose of my sql?

1006

---

what does myisamchk do? : Sql dba

1075

---

Can we write ddl statements in functions?

1177

---

What is the difference between a query and a report?

1050

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1156

---

What is primary key secondary key alternate key candidate key?

1077

---

What is the need of a partition key?

1025

---

Which join is like an inner join?

1088

---

Is sql developer case sensitive?

1042

---