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 are the different type of normalization? : Sql dba
Which is the best place to learn hadoop?
How many commands are in sql?
what are the performance and scalability characteristics of mysql? : Sql dba
what happens if null values are involved in expressions? : Sql dba
how to check myisam tables for errors? : Sql dba
What are predefined functions in sql?
What is embedded sql with example?
What are hotfixes and patches?
Define overloaded procedure?
what is meant by forward declaration in functions?
Does db2 use sql?
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)