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



If records are inserted into table without committing.How to refer to these values in a procedure..

Answer / highness

good,



isn't it possible by using :new pseudo records within
a trigger???

Is This Answer Correct ?    1 Yes 0 No

If records are inserted into table without committing.How to refer to these values in a procedure..

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

Post New Answer

More SQL PLSQL Interview Questions

Can we use pl sql in mysql?

0 Answers  


Explain the savepoint statement.

0 Answers  


What is Difference between StoredProcedure and function?

3 Answers  


Does sql backup shrink transaction log?

0 Answers  


What is the differnce between view and materialized view

4 Answers   TCS,






What is right join sql?

0 Answers  


What is the current version of sql?

0 Answers  


Name some usages of database trigger?

0 Answers  


What is clustered and non-clustered indexes?

4 Answers   Microsoft,


Can we rollback delete command?

0 Answers  


What are the datatypes a available in PL/SQL ?

2 Answers  


What is the difference between a subquery and a join?

0 Answers  


Categories