i want insert 10 records from table a to table b.
if i m using statement level trigger how many record insert
?in row level trigger how many record inserted???

Answer Posted / satheesh

statement level trigger=10
but row level trigger=1

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you have more than one trigger on a table?

519


What are the properties of a transaction?

548


Why is sql*loader direct path so fast?

589


what is innodb? : Sql dba

569


What is keys and its types?

530






what is a tablespace? : Sql dba

555


Explain how exception handling is done in advance pl/sql?

542


What are the types of subqueries?

566


What is a table partition?

581


What is a trigger word?

505


What is a table in a database?

565


What packages are available to pl/sql developers?

584


What is sql profiling in oracle?

533


What is the difference between the sql*loader and import utilities? : aql loader

589


What do you mean by query optimization?

539