Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / rajuchaitu

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 cte?

0 Answers  

What is sql and explain its components?

0 Answers  

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

what is auto increment? : Sql dba

0 Answers  

How subquery works in sql?

0 Answers  

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

Is sql considered coding?

0 Answers  

what are properties of a transaction? : Sql dba

0 Answers  

Can we commit inside a trigger?

0 Answers  

Is and as keyword in pl sql?

0 Answers  

full outer join syntax

5 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories