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
- 16741 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
what is user defined functions? : Sql dba
What is null in pl/sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is replication id?
What is scope of pl sql developer in future?
What is pl sql architecture?
What are stored procedures in mysql?
What is the use of nvl function?
How do I run sql?
what does myisamchk do? : Sql dba
What is the syntax to add a record to a table?
What is a composite primary key?
What is nosql db?
How many sql commands are there?
Can you inner join the same table?
