if i am using dml statement in function.
then i am writing select statement what was the output
- 2 Answers
- 3682 Views
- MasterCard, I also Faced
- E-Mail Answers
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 |
How to convert a string to a date in oracle database?
difference between oracle8i and oracle9i
What are the attributes that are found in a cursor?
What do you mean by cdb and pdb in oracle 12c?
What is the difference between substr and instr?
Explain about functional dependency and its relation with table design?
How do I uninstall oracle client from windows?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
Explain the different normalization forms?
What is oracle database 10g express edition?
What is meant by a deadlock situation?
can you explain performance tunning in oracle(sql,PL/SQL)
Oracle General 
