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 the starting oracle error number?

569

Can we call a function containing dml statements in a select query?

548

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

556

What is sql and db2?

538

Can you join views in sql?

546

What are pl/sql cursors?

567

What is lexical units in pl sql?

579

How to load data with sql*loader?

552

What is a trigger in sql?

642

Do foreign keys improve performance?

551

What can I use instead of union in sql?

518

How to return multiple rows from the stored procedure?

526

how to enter binary numbers in sql statements? : Sql dba

493

Is pl sql better than sql?

557

what is subquery? : Sql dba

575