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
- 4345 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
How to use subqueries with the in operator using oracle?
What is recycle bin in Oracle?
Explain the use of record length option in exp command.
What is system tablespace?
Explain the features of oracle?
How to pass parameters to procedures in oracle?
Why use resource manager in Oracle?
How to call a stored function in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to add a new column to an existing table in oracle?
What are the arithmetic operations?
what are bitmap indexes? How does they work?
What is proxy method?
What is a named program unit?
What do you mean by merge in oracle and how can we merge two tables?
