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 spool?
What are the different sql languages?
Explain the difference between rename and alias?
what is primary key? : Sql dba
Can a primary key be a foreign key?
Define concurrency control. : Transact sql
What is scalar and vector?
How does one load ebcdic data? : aql loader
Why do we need unique key in a table?
How many tables can a sql database have?
What is sql keyword?
what is the command line end user interface - mysql? : Sql dba
Oracle (3259)
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)