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 |
What is secondary key?
How do you sort in sql?
what are integrity rules?
What is time based sql injection?
display records from 5 to 9 using rowid or rownum
What are dml commands?
Why do we use joins in sql?
How do I view stored procedures?
what is difference between procedure and function
10 Answers MCN Solutions, Wipro,
What is the diffrence between IN and EXISTS.which one is faster.
What is sql deadlock?
discuss about myisam index statistics collection. : Sql dba
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)