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 |
What are the different pseudo commands? Explain in general?
What happens to the current transaction if the session is ended?
What are the Limitations of a CHECK Constraint ?
How to run create database statement again?
How to get a list of all background sessions in the database?
How to sort output in descending order in oracle?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
What is Trigger in Oracle?
How to display row numbers with the records?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
What is tns name?
who is the father of oracle and send chodd rules