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 |
Is time a data type in sql?
What is pl sql package?
Is mariadb nosql?
How many commands are in sql?
Which sql most popular?
How do I start sql profiler?
How many types of privileges are available in sql?
How to handle bulk data?
Which join condition can be specified using on clause?
what is the difference between union and union all
14 Answers IBM, Luxoft, Oracle,
Can we have exception part in trigger ?
What is audit logout in sql profiler?
Oracle (3253)
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)