if i am using dml statement in function.
then i am writing select statement what was the output
Answers were Sorted based on User's Feedback
Answer / jayashree
DML cant be performed in Function. There would be no change.
Is This Answer Correct ? | 3 Yes | 3 No |
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 |
Which environment variables are absolutely critical in order to run the OUI?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
What is the difference between sharding and partitioning?
what is insert all statement in sql
what are stored procedures?
What is the dynamic sql in oracle?
difference between imlicit cursor and explicit cursor ?
What are the limitations of check constraint?
How can I create database in oracle?
Explain about integrity constraint?
what is the use of ondelete cascade?
What are the different types of trigger and explain its various uses and functions?