We can call a function in sql query if we declare function as PRAGMA AUTO

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

Question Posted / venu

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is recursive join in sql?

752

Is sql open source?

713

what is data control language? : Sql dba

746

Can we use ddl statements in stored procedure?

881

Explain foreign key in sql?

786

What is posting?

779

What is multiple partition?

696

What is function and procedure in pl sql?

702

What are sql indexes?

740

What is tuple in sql?

732

What is a Mapplet?

824

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

760

What is a temp table?

746

What is difference between table and view?

706

What is sap sql?

717