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 Primary Key?
How do you get column names only for a table (sql server)?
What are the types of views in sql?
What is difference sql and mysql?
What is the usage of NVL?
7 Answers Infosys, Micro Infotek,
what is cursor procedure
Explain character-manipulation functions?
what is offset-fetch filter in tsql? : Transact sql
what is the difference between blob and text? : Sql dba
How to get each name only once from an employee table?
What view means?
What are the different types of tables in 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)