How to call a trigger inside a stored procedure?Give an
example.
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 |
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
What are Clusters ?
What are the oracle differences between nvl and coalesce
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Give the various rollback segment states.
What privilege is needed for a user to create views in oracle?
How you find out version of installed workflow?
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
Differentiate between post-database commit and post-form commit?
Explain the use of log option in exp command.
How to use an explicit cursor without open statements?
How to invoke the data pump export utility?