If records are inserted into table without committing.How
to refer to these values in a procedure?
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 bulk collect in pl sql?
What is the difference between an inner and outer join?
How does left join work in sql?
how to include comments in sql statements? : Sql dba
what is row? : Sql dba
What is view? Can we update view
how to concatenate two character strings? : Sql dba
Can we create clustered index without primary key?
Mention what is the plv (pl/vision) package offers?
What are the types of triggers in sql?
What do you mean by rowid?
What is the sql*loader? : aql loader
what is cursor. write example of it. What are the attributes of cursor.
What is a database? Explain
What is sql trigger example?