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

How will you distinguish a global variable with a local variable in pl/sql?

1153

When do we use triggers?

1078

Is natural join same as inner join?

940

what is single byte over head in oracle..?

2401

Is and as keyword in pl sql?

961

What is not equal in sql?

1123

what is difference between delete and truncate commands? : Sql dba

1131

State few characteristics of pl/sql?

971

Define concurrency control. : Transact sql

1191

what are the advantages of mysql in comparison to oracle? : Sql dba

1004

Inline the values in PL/SQL, what does it mean.?

1226

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1168

Is it possible to create startup or shutdown trigger for on-schema?

1029

what is foreign key? : Sql dba

1048

Is sql a oracle?

978