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 does the argument [or replace] do?

1064

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

1144

Is left join same as join?

972

how to drop an existing view in mysql? : Sql dba

1043

How do I run a sql query?

1001

What are data types in pl sql?

1126

What is set transaction?

1019

How do you run a query?

980

What is delimiter in pl sql?

1038

how can we destroy the session, how can we unset the variable of a session? : Sql dba

981

What is natural join in sql?

962

What is sqlite format?

1173

Can we use join in subquery?

1073

What is mutating error in pl sql?

1002

What is use of package in pl sql?

994