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
- 4265 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 |
How to empty your oracle recycle bin?
How do you rate yourself in oracle and sql server ?
What are the different types of database objects?
How to do paging with oracle?
What privilege is needed for a user to create indexes in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to list all user accounts in oracle?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What happens to the current transaction if a ddl statement is executed?
What is archive log in Oracle?
How do I spool to a csv formatted file using sqlplus?
Oracle General 
