What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE
TRIGGERS ?



What is the usuage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ?..

Answer / guest

These triggers are executes when inserting,deleting and
updating operations are performed and can be used to
change the default function of insert,delete or update
respectively.

For Eg, instead of inserting a row in a table an
existing row can be updated in the same table.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Forms Reports Interview Questions

I am using oracle developer suit(form 10g), On used ole2 objects to initialize excel and worksheet and on "BEFORE REPORT" i am printing report heading in excel using OLE2 objects only. if i run report from developer suit report builder it give output in excel normally and what expected but when ever i put same report on server and run report from application it gives error : " Terminated with error : <br> REP-1401 'before report': FATAL pl/sql error occured. ORA-43356; message 43356 not found; Product=RDBMS; facility = ORA." Please reply it is urgent

0 Answers  


What are the default extentions of the files created by menu module?

1 Answers  


how i build a report

1 Answers  


how to call forms in parametar forms

2 Answers  


What is the maximum size of a form ?

1 Answers  


What are the built-in routines is available in forms 4.0 to create and manipulate a parameter list?

1 Answers  


Is it possible to split the printpreviewer into more than one region?

1 Answers  


Can a field be used in a report wihtout it appearing in any data group?

1 Answers  


What is lexical parameter ?

2 Answers   Zensar,


Can you mention lexical parameter in select statement in the data model?

1 Answers   Zensar,


How i get the client m/c IP address.

2 Answers  


what is the difference between call_form, new_form and open_form?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)