Answer / sharad kumar

1. Function must return a value like any other Programing
Language.
2.yes we can call function from a DML.Remember count(*),sum
etc...

Answer / 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 composite primary key in sql?

0 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

What is an inner join sql?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

what are the advantages of sql ? : Sql dba

0 Answers  

---

What is mutating trigger?

0 Answers  

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

What is dba in sql? : SQL DBA

0 Answers  

---

Explain the working of foreign key?

0 Answers  

---

Why do we use view in sql?

0 Answers  

---

how to create temparary sequence

2 Answers   TCS,

---