Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / swapna

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

What is output spooling in sql*plus?

0 Answers  

Store procedure will return a value?

4 Answers   eMids,

Can we create clustered index without primary key?

0 Answers  

How to change sql*plus system settings?

0 Answers  

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,




What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

How to process query result in pl/sql?

0 Answers  

What is the difference between functions, procedures, and packages in pl/sql?

0 Answers  

What is rowid in sql?

0 Answers  

Is sql the best database?

0 Answers  

How many sql commands are there?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories