if i am using dml statement in function.
then i am writing select statement what was the output
Answer Posted / 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 View All Answers
What is merge in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What are named parameters?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to lock and unlock a user account in oracle?
What is the difference between truncate & delete command?
Explain the use of indexes option in imp command.
Please explain compound trigger in oracle?
Compare and contrast between sql and sql server and explain its various functions?
What are the different editions of oracle?
What is BBED in Oracle?
How can I introduce multiple conditions in like operator?
interview questions with answer for cts
How to use fetch statement in a loop?
Explain the use of consistent option in exp command.