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
- 15679 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / rj
Hello. if any one of them insert statement is wrong then no
data is inserted.
if you used commit statemnt then it also not work means no
data will be saved in table
Thanks
K.....
please write this example and run
i have only change data type in second insert statemnet
create or replace procedure test_emp
begin
insert into emp(EMPNO, ENAME)
values(1,'R');
insert into emp(EMPNO, ENAME)
values(TEST,'01');
insert into emp(EMPNO, ENAME)
values(2,'S');
commit;
end;
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
how to convert dates to character strings? : Sql dba
How do you write an index?
What are user defined functions?
what are null values? : Sql dba
what are the 'mysql' command line arguments? : Sql dba
How does stored procedure reduce network traffic?
How to rename a table?
What is primary key and foreign key with example?
What is microsoft t sql?
What is over () in sql?
Can pl sql procedure have a return statement?
which types of join is used in sql widely? : Sql dba
how to enter numeric values as hex numbers? : Sql dba
Is nosql faster than sql?
Explain the methods used to protect source code of pl/sql.
