Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

if a table is getting updated what happens if a function is
called from sql query?

Question Posted / rajuchaitu

Answers were Sorted based on User's Feedback



if a table is getting updated what happens if a function is called from sql query?..

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

if a table is getting updated what happens if a function is called from sql query?..

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

Post New Answer

More SQL PLSQL Interview Questions

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

What is coalesce in sql?

0 Answers  

What are pl/sql exceptions? Tell me any three.

1 Answers  

If the base table structure is changed what will happen to join index????

2 Answers  

What is sql performance tuning?

0 Answers  




What is the mutating table and constraining table?

0 Answers  

Types of backups ?

3 Answers   TCS,

What are all different types of collation sensitivity?

0 Answers  

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

Explain cursor types?

0 Answers  

how is myisam table stored? : Sql dba

0 Answers  

what is data control language? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories