adspace


While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?

Answer Posted / rajeshwaran

First two rows will be inserted and the third entry will
cause Run time error and the execution will be terminated
by inserting first two rows into the table.

Is This Answer Correct ?    4 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is collation? : Sql dba

1229


What is your daily office routine?

2346


Do we need to rebuild index after truncate?

1138


If a cursor is open, how can we find in a pl/sql block?

1238


what is dbms? : Sql dba

1061


Is inner join faster than left join?

1277


how to escape special characters in sql statements? : Sql dba

1114


How do I remove duplicates in two columns?

1187


what are aggregate and scalar functions? : Sql dba

1129


how to use regular expression in pattern match conditions? : Sql dba

1113


What is the current version of postgresql?

1178


how many tables will create when we create table, what are they? : Sql dba

1144


Is primary key clustered index?

1019


define sql insert statement ? : Sql dba

1098


what is bcp? When does it used? : Sql dba

1056