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 |
Delete duplicate records in the emp table.
What is an inner join sql?
what are the difference between clustered and a non-clustered index? : Sql dba
wa procedure to return the month and the no'f developers joined in each month.
what are the advantages of sql ? : Sql dba
what is meant by tuning and tk proof?
differentiate between float and double. : Sql dba
what is an index? : Sql dba
What is java sql drivermanager?
Write a sql query to get the third highest salary of an employee from employee_table?
how can stop the sequence with mention the max value and with out mention the max value
What are the different type of joins 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)