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
- 9252 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 are properties of a transaction? : Sql dba
Explain the structure of pl/sql in brief.
What are basic techniques of indexing?
What is Referential Integrity?
what is bdb (berkeleydb)? : Sql dba
How to look at the current sql*plus system settings?
explain primary keys and auto increment fields in mysql : sql dba
what are the 'mysql' command line options? : Sql dba
What is normalization ?
9 Answers BirlaSoft, CTS, HCL,
What is sql resultset?
Which join is like an inner join?
What is difference between stored function and application function?
-
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)
