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 will you get by the cursor attribute sql%rowcount?

1037

---

What is nvarchar in sql?

924

---

what is a database transaction? : Sql dba

1181

---

Why commit is not used in triggers?

1038

---

Can we join more than 2 tables in sql?

1019

---

What is a schema? How is it useful in sql servers?

1119

---

What is %type in pl sql?

966

---

What does select * from mean in sql?

3236

---

Is a view faster than a stored procedure?

969

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2571

---

How do I partition a table in sql?

1129

---

What are different types of sql commands?

1117

---

What is rowtype?

1019

---

Is pl sql better than sql?

1031

---

how to drop an existing table in mysql? : Sql dba

1044

---