if i am using dml statement in function. then i am writing select statement wha

if i am using dml statement in function.
then i am writing select statement what was the output

Question Posted / nishi.swain@gmail.com

2 Answers
3268 Views
MasterCard, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if i am using dml statement in function. then i am writing select statement what was the output..

Answer / jayashree

DML cant be performed in Function. There would be no change.

Is This Answer Correct ?

3 Yes

3 No

if i am using dml statement in function. then i am writing select statement what was the output..

Answer / sandeeptiwari1111@gmail.com

We can perform DML operation in function but we can not Query that function in select statement.
But if you want to query it any how from select stmnt then you have to use Pragma_autonomous transaction .

create or replace function f2 return date as
Pragma Autonomous_Transaction;

begin

insert into Tab values(sysdate);
commit;
return sysdate-1;

end ;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer