Interested to Buy Any Domain ? << Click Here >> for more details...
How to call a trigger inside a stored procedure?Give an
example.
- 2 Answers
- 8844 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manikandan. s
triggers can't be called from procedures or functions
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / jay
Inside procedure, insert/update/delete the row in table.
The table will automatically fire the trigger. Trigger will
get fire automatically.
| Is This Answer Correct ? | 8 Yes | 2 No |
What is a nvl function? How can it be used?
What is the scope of a local variable?
What is the difference between an Oracle Schema and an Oracle Instance?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
What is the difference between substr & instr functions?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
how to produce numbers from 1 to 10 using dual table
How to invoke the original export import utilities?
What are the trigger associated with image items ?
Can we commit inside a function in oracle?
What are the differences between blob and clob in oracle?
Oracle General 
