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

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

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,


What is a design view?

0 Answers  


How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,


how do you know the version of your mysql server? : Sql dba

0 Answers  


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

3 Answers   Scope International,






What is string data type in sql?

0 Answers  


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  


How to create your own reports in sql developer?

0 Answers  


SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  


i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  


What are all ddl commands?

0 Answers  


how to rename an existing table in mysql? : Sql dba

0 Answers  


Categories