how many triggers we can create on a table

Answers were Sorted based on User's Feedback



how many triggers we can create on a table..

Answer / venu

total 13 triggers with instead of trigger

Is This Answer Correct ?    8 Yes 20 No

Post New Answer

More Oracle General Interview Questions

Can a Tablespace hold objects from different Schemes ?

3 Answers  


In what script is snap$ created? In what script is the scott/tiger schema created?

0 Answers  


How to recover a dropped table in oracle?

0 Answers  


What is enter substitution variable in oracle?

0 Answers  


What is the string concatenation operator in oracle?

0 Answers  






How to display the hierarchy of employee and managers without using connect by prior.

1 Answers  


How to create a stored program unit?

0 Answers  


Can we create trigger on materialized view in oracle?

0 Answers  


Please explain joins in oracle?

0 Answers  


what is pragma?

2 Answers  


Differentiate between TRUNCATE and DELETE?

2 Answers  


how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

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)