if a table is getting updated what happens if a function is
called from sql query?
Answers were Sorted based on User's Feedback
Answer / sumit
No function can be called from a sql query if the function
has dml statements inside.
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / 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 |
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is the main reason behind using an index?
What is not null in sql?
How do you handle exceptions. Give the syntax for it?
how can we know the number of days between two given dates using mysql? : Sql dba
IF i write before / after insert / update trigger and i do rollback what will happen?
How do I audit the sql sent to the server?
What is the basic difference between a sql and stored procedure ?
What is difference sql and mysql?
wtite down triggr not any entry on Sunday
What is procedure and function?
How do I create an index in word?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)