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
- 4248 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 |
Explain the use of record length option in exp command.
Can anyone give me information about oracle certification
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
can we insert any row to dual table if i got the permission from DBA
What is Read-Only Transaction ?
How to use "startup" command to start default instance?
what is meant by magic query
what is view?
What is the difference between view and materialized view in Oracle?
Write query to fetch second maximum salary from employee table.
4 Answers Bravura Solutions, HCL,
Explain an exception and its types?
Oracle General 
