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

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

Question Posted / rajuchaitu

2 Answers
9274 Views
RBS, I also Faced
E-Mail Answers

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

What is the use of sql trace?

0 Answers

what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers

Can a view be mutating? If yes, then how?

0 Answers

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers iNautix, Oracle,

What are sql constraints?

0 Answers

What is sql and also describe types of sql statements?

0 Answers

how to enter characters as hex numbers? : Sql dba

0 Answers

What is delimiter sql?

0 Answers

What are transaction and its controls?

0 Answers

what is log shipping? : Sql dba