Interested to Buy Any Domain ? << Click Here >> for more details...
A table t is there.If you perform insert
,update and delete then the trigger will fire.What is
the minimum no of trigger required for a table.
- 3 Answers
- 5525 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / suresh babu
You can finish those all actions by using only one Trigger
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / basanti jena
You can get it by using 1 trigger but maximum 12 trigger
| Is This Answer Correct ? | 4 Yes | 0 No |
Explain the use of compress option in exp command.
What is max rowid in oracle?
What is the implicit cursor in oracle?
How many types of cluster table in Oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is the oracle implicit cursor?
Explain an exception and its types?
how to get the index id?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What is catalog in Oracle?
How to commit the current transaction in oracle?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
Oracle General 
