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
- 9293 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 an execution plan? When would you use it? How would you view the execution plan? : Sql dba
how to get a list of indexes of an existing table? : Sql dba
What is the difference between joins?
What is indexes?
What is the difference between delete and truncate statement in sql?
What is the difference between an inner and outer join?
What is the difference between union and union all command?
there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?
What is the fastest way of accessing a row in a table?
What is a unique key?
How to find only %th Highest Sal
When are we going to use truncate and delete?
-
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)
