if a table is getting updated what happens if a function is
called from sql query?
Answer Posted / venu
We can call a function in sql query if we declare function
as PRAGMA AUTONOMOUS TRANSACTION.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
what is csv? : Sql dba
What is foreign key sql?
What is sql used for?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Can a select statement fire a trigger?
What does sign mean sql?
What is sql trigger example?
What is the command used to fetch first 5 characters of the string?
What is nosql vs sql?
What is thread join () in threading?
Is left join faster than join?
What is the difference between a procedure and a function?
What is an exception in pl/sql?
What is the difference between inner join and outer join?
How to change sql*plus system settings?