Interested to Buy Any Domain ? << Click Here >> for more details...
if i am using dml statement in function.
then i am writing select statement what was the output
- 2 Answers
- 4444 Views
- MasterCard, I also Faced
- E-Mail Answers
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 an anonymous block?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is Library Cache in Oracle?
How is it different from a normal table?
How to import one table back from a dump file?
How to list all user accounts in oracle?
How to recover a dropped table in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How view is different from a table?
How to define a variable of a specific record type?
How to shutdown your 10g xe server?
How to update values on multiple rows in oracle?
what is the use of system.effective.date variable in oracle?
What is an external table?
