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 is trigger?
ABOUT IDENTITY?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to create a server parameter file?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is SYSTEM tablespace and When is it Created?
Explain the difference between a procedure and a function? What do you understand by those terms?
what's query optimization and without use of IN AND Exist can we get another way data from query
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
What is a user account in oracle?
How to define an external table with a text file?