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

Are sql connections encrypted?

558


What are the sql commands?

608


What is a data definition language?

556


how to rename an existing column in a table? : Sql dba

511


Why do we need unique key in a table?

526






Does google use sql?

512


How do I install sql?

522


Can we create a trigger on view?

489


How many tables can you join in sql?

533


How can I speed up sql query?

524


Which data type is a composite type?

532


Is subquery faster than join?

570


What is cascade in sql?

561


ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2006


What is rank () in sql?

534