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

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 Answers  

What is sql indexing?

0 Answers  

Difference between a query and strored procedure?

4 Answers   Microsoft,

what is row? : Sql dba

0 Answers  

What is a primary key sql?

0 Answers  




Enlist the data types that can be used in pl/sql?

0 Answers  

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

For more SQL PLSQL Interview Questions Click Here
Categories