Interested to Buy Any Domain ? << Click Here >> for more details...
If records are inserted into table without committing.How
to refer to these values in a procedure?
- 2 Answers
- 7520 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
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Explain clause in sql?
what is a database transaction? : Sql dba
What are sql objects?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is prepared statement in sql?
how can we find the number of rows in a table using mysql? : Sql dba
how to calculate expressions with sql statements? : Sql dba
Which command is used to call a stored procedure?
Which sql most popular?
What is a record in pl/sql?
What is column?
Can variables be used in sql statements?
Why is pl sql needed?
what is try_catch block in procedure
