Interested to Buy Any Domain ? << Click Here >> for more details...
if a table is getting updated what happens if a function is
called from sql query?
- 2 Answers
- 9169 Views
- RBS, I also Faced
- E-Mail Answers
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 |
What is difference sql and mysql?
Which join is like an inner join?
What is the advantage of index in sql?
What is meant by cursor in sql?
how is exception handling handled in mysql? : Sql dba
List the ways to get the count of records in a table?
What is scalar function?
What are the possible values for the boolean data field?
What is a sql instance vs database?
What is trigger explain with example?
What is a sql trace file?
What is t sql used for?
-
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)
