First create a Trigger and with Procedure you insert records. The :new w

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

Question Posted / swapna

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is nvl?

1018

How to run sql commands in sql*plus?

1082

What is not null in sql?

987

What is sql*loader and what is it used for? : aql loader

1097

What is pl sql block in dbms?

952

In a distributed database system, can we execute two queries simultaneously?

998

What are analytical functions in sql?

972

what is 'mysqlshow'? : Sql dba

975

What is sqlite used for?

935

How do you remove duplicate records from a table?

887

What is prepared statement in sql?

998

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1094

What do you mean by table in sql?

941

How many indexes can be created on a table in sql?

989

How do I partition a table in sql?

1045