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
- 9302 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's the difference between inner join and left join?
what is the difference between a local and a global temporary table? : Sql dba
what are the differences among rownum, rank and dense_rank? : Sql dba
what is bcp? When is it used?
Why we use joins in sql?
i need department wise top 2 employees salary.which logic i will use
Why are indexes and views important to an organization?
What is a system versioned table?
What is the syntax and use of the coalesce function?
How to display the current date in sql?
What is difference between inner join and cross join?
Is id a reserved word in sql?
-
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)
