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
- 4450 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 I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
How are the index updates?
How to call a sub procedure?
What are privileges and grants?
How to rename an existing table?
Why do we need integrity constraints in a database?
How to drop a stored procedure in oracle?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
How to pass a parameter to a cursor in oracle?
State any two functions of oracle?
How can I create database in oracle?
Can anyone give me information about oracle certification
Oracle General 
