Is it possible to use function inside a trigger.

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

Code
span style="font-style: italic;">--referencing old as old and new as new

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

Yes, by using CALL statement.

Answer Question  Select Best Answer

What are bind variables in sql? explain in detail?

pradipta

 Profile Answers by pradipta Questions by pradipta

• Feb 8th, 2014

The way to get Oracle to reuse the execution plans for "the statements having different hard coded value in where clause" there should use bind variables. Bind variables are ?substitution? variable...

Aarti

• Jan 15th, 2014

Bind variable is session specific variable. It is declared using variable keyword. Bind variable cant be used in named block. It cant have default value.

Answer Question  Select Best Answer

Raviteja

 Profile Answers by Raviteja Questions by Raviteja

• Aug 23rd, 2014

Instead of cursor is not there,, instead of trigger is used incase of complex views. when we use views with joins

Kumar

• Jul 25th, 2014

Its instead of trigger not cursor and it is used to apply trigger on views.

Answer Question  Select Best Answer

BASAVARAJ KOLUR

• Mar 9th, 2007

plsql supports mainly 3 types of collections    1> index by binary_integer    2> nested table    3>varrays index by binary_integer and nested...

Gupta

• Aug 7th, 2006

Types are Index -by- table, Nested Tables and Varray!

Answer Question  Select Best Answer

What are analytical functions and how are they used?

singh.neerajin

 Profile Answers by singh.neerajin Questions by singh.neerajin

• Jul 22nd, 2008

Analytic functions compute an aggregate value based on a group of rows. They differ from aggregate functions in that they return multiple rows for each group. The group of rows is called a window and ...

Answer Question  Select Best Answer

Procedure A calls procedure B. A updates table t1, t2. B updates table t3. If some error happens to B what happens to the updates in all those tables? Whether they will rollback or commit? If commits how far it will commit?

vishal.bhadange

 Profile Answers by vishal.bhadange Questions by vishal.bhadange

• Aug 24th, 2013

CASE 1 (If you are not handling exception in Procedure B, none of the table gets updated) "sql PROCEDURE A BEGIN UPDATE TABLE t1; UPDATE TABLE t2; CALL PROCEDURE ...

Answer Question  Select Best Answer

Hi ,can any one tel pls what is use ofprocedures and packages? why we use can anyone tell me with one real time example

HEMA NAGARAJU

• Dec 20th, 2014

Procedures are dataobjects which are stored in a database. We can define an operation in procedure and we call the procedure many times in the application. Packages are collection of subprograms, pro...

Answer Question  Select Best Answer