If records are inserted into table without committing.How
to refer to these values in a procedure?
Answers were Sorted based on User's Feedback
Answer / highness
good,
isn't it possible by using :new pseudo records within
a trigger???
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swapna
First create a Trigger and with Procedure you insert
records.
The :new will take the new values.
So use Triggers in Procedures.
Is This Answer Correct ? | 0 Yes | 0 No |
Can we use pl sql in mysql?
Explain the savepoint statement.
What is Difference between StoredProcedure and function?
Does sql backup shrink transaction log?
What is the differnce between view and materialized view
What is right join sql?
What is the current version of sql?
Name some usages of database trigger?
What is clustered and non-clustered indexes?
Can we rollback delete command?
What are the datatypes a available in PL/SQL ?
What is the difference between a subquery and a join?