Interested to Buy Any Domain ? << Click Here >> for more details...
While inserting 10 rows using procedure, if 3rd entry is
having some error, what will be the output? How u will
handle that error?
- 8 Answers
- 16731 Views
- iFlex, I also Faced
- E-Mail Answers
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
What are sql functions? Describe the different types of sql functions?
How do sql triggers work?
What is an ndf file?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is the difference between syntax error and runtime error?
How run sql*plus commands that are stored in a local file?
tell us something about heap tables. : Sql dba
How to add a column ‘salary’ to a table employee_details?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
is it possible to pass an object or table to a procedure as an argument?
Can we group by two columns in sql?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
what is the difference between cluster and non cluster index? : Sql dba
How are functions and procedures called in PL/SQL?
Why stored procedure is better than query?
