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 / 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
What is a field in a database?
Advantages and disadvantages of stored procedure?
What is #table in sql?
How do you change a value in sql?
Is inner join same as self join?
What is over () in sql?
What is pl sql code?
How can a pl sql block be executed?
Why is normalization important?
What are the different dcl commands in sql?
What is the cause of mutating table error and how can we solve it?
What are packages in pl sql and also explain its advantages?
how to select first 5 records from a table? : Sql dba
What is the difference between execution of triggers and stored procedures?
What is trigger in pl sql?