If records are inserted into table without committing.How
to refer to these values in a procedure?
- 2 Answers
- 6983 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between null value, zero, and blank space?
Why do we use partitions in sql?
How do I run sql?
Which sorts rows in sql?
What does data normalization mean?
What does t sql mean?
Write the alter statement to enable all the triggers on the t.students table.
Why do we need view in sql?
what is commit? : Sql dba
what are all types of user defined functions? : Sql dba
Where can I learn sql for free?
Explain lock escalation? : Transact sql
What is cartesian join in sql?
what is view? : Sql dba
what are the performance and scalability characteristics of mysql? : Sql dba
