i want insert 10 records from table a to table b. if i m using statement level

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???

Question Posted / jprakash025

3 Answers
9623 Views
Scope International, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i want insert 10 records from table a to table b. if i m using statement level trigger how many re..

Answer / jprakash025

st lvl-10
and also row lvl-10

Is This Answer Correct ?

29 Yes

7 No

i want insert 10 records from table a to table b. if i m using statement level trigger how many re..

Answer / ganesh kumar

good.

Is This Answer Correct ?

1 Yes

0 No

i want insert 10 records from table a to table b. if i m using statement level trigger how many re..

Answer / satheesh

statement level trigger=10
but row level trigger=1

Is This Answer Correct ?

3 Yes

3 No

Post New Answer

More SQL PLSQL Interview Questions

Why join is faster than subquery?

0 Answers

What is break?

0 Answers

What is dbo in sql?

0 Answers

How do I run sql profiler?

0 Answers

What is rtm in testing?

0 Answers

What is your daily office routine?

0 Answers Data Vision,

What are the two parts of a procedure ?

6 Answers Hi Caliber IT,

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers Fidelity, IBM,

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers Satyam,

what is recursive stored procedure? : Sql dba

0 Answers

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers

what is the different between now() and current_date()? : Sql dba

0 Answers

For more SQL PLSQL Interview Questions Click Here