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
- 4371 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 |
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
What is the maximum number of CHECK constraints that can be defined on a column ?
various types of joins
What is a sub query? Describe its types?
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
1) Does oracle have any table which contain all the exceptions and it's code internally?
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
How to use like conditions in oracle?
How to login to the server without an instance?
What are the built-in functions used for sending Parameters to forms ?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
How to use "in out" parameter properly?
Oracle General 
