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 |
Explain isolation levels. : Transact sql
which will default fire first statement level trigger or row level trigger
2 Answers Cap Gemini, Data Vision,
How do I edit a trigger in sql developer?
how can i read files from a pl/sq l program
Why we use sql profiler?
Can we have two clustered index on a table?
What are crud methods?
explain the difference between bool, tinyint and bit. : Sql dba
How can you load multi line records? : aql loader
Is sql considered coding?
What is coalesce in sql?
Can we create foreign key without primary key?
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)