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

Is inner join same as self join?

0 Answers  

What is normalization sql?

0 Answers  

What are the types of keys?

0 Answers  

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,




What is the use of sqldataadapter?

0 Answers  

What are character functions in sql?

0 Answers  

what is explain plan?

4 Answers  

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

Which join is default?

0 Answers  

What is record in pl sql?

0 Answers  

Is sql workbench free?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories