How many types of trigger can be used in a table at a time ?

Answers were Sorted based on User's Feedback



How many types of trigger can be used in a table at a time ?..

Answer / sree

max of 12

Is This Answer Correct ?    19 Yes 2 No

How many types of trigger can be used in a table at a time ?..

Answer / arun raj

u can define a trigger
1. For Each Row
2. For Each Statement

You can have the following triggers defined for the above
two types:
1. BEFORE INSERT
2. BEFORE UPDATE
3. BEFORE DELETE
4. AFTER INSERT
5. AFTER UPDATE
6. AFTER DELETE

So it makes a total of 12.

Is This Answer Correct ?    15 Yes 0 No

How many types of trigger can be used in a table at a time ?..

Answer / shweta

max 12

Is This Answer Correct ?    11 Yes 5 No

How many types of trigger can be used in a table at a time ?..

Answer / shanmugavelu

Max 12 types we can use before/after combination

Is This Answer Correct ?    8 Yes 4 No

How many types of trigger can be used in a table at a time ?..

Answer / a.kondala rao.

1 at a time

Is This Answer Correct ?    4 Yes 3 No

How many types of trigger can be used in a table at a time ?..

Answer / a.kondala rao.

one trigger at a time

Is This Answer Correct ?    5 Yes 4 No

How many types of trigger can be used in a table at a time ?..

Answer / jagadesh

12

Is This Answer Correct ?    4 Yes 4 No

Post New Answer

More Oracle Forms Reports Interview Questions

Hi...... I created a report which is geneated in .txt format. What I do for this is 1.First I change the system parameter mode to character in the report. 2.Then I place a button in my form to call the report. code in the button is as follows.. DECLARE rePid REPORT_OBJECT; rep_hndl VARCHAR2(100); BEGIN rePid := Find_Report_Object('reptxt.rdf'); Set_Report_Object_Property(rePid,Report_deStype,FILE); Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf'); Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt'); rep_hndl := Run_Report_Object(rePid); END; and it is working.. Now the problam is that when I preview the report from the report builder, it is in the format I needed. But when I run the form and run the report,Its alligment is not correct. Regards abc

1 Answers  


How can a text file be attached to a report while creating in the report writer?

1 Answers  


sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How?

1 Answers   ESS,


what is the difference between call_form, new_form and open_form?

0 Answers  


What is the difference when confine mode is on and when it is off?

1 Answers  






What is an Invoice ? How many types of invoices are there in AP and AR ?

3 Answers  


Can a root window be made modal?

1 Answers  


What is the sequence the Report triggers will fires while running a report ?

1 Answers   FCS, GE,


what is Oracle10g? Please refer some sites...

1 Answers  


How can you create Lexical parameter n Bind parameter in Reports ?

1 Answers   GE, SVSS,


what are different types of canvas views?

3 Answers  


What is a combo box?

2 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • 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)