If records are inserted into table without committing.How
to refer to these values in a procedure?
- 2 Answers
- 6572 Views
- I also Faced
- E-Mail Answers
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 before and after trigger?
What is sql architecture?
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
What is the maximum size of sqlite database?
What are different categories of sql commands?
What are different types of sql?
Why do we use partitions in sql?
what is primary key? : Sql dba
What are synonyms in sql?
How many row comparison operators are used while working with a subquery?
What is time based sql injection?
What are crud methods?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
