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;

How can you view the errors encountered in a trigger?

954

---

What is difference between joins and union?

1116

---

What are the different types of a subquery?

1044

---

Is sql procedural language?

960

---

How do you declare a user-defined exception?

1018

---

What types of commands can be executed in sql*plus?

1102

---

what is the difference between blob and text? : Sql dba

1007

---

What is primary key and foreign key?

955

---

How many developers work on postgresql?

968

---

What is row_number () in sql?

976

---

what are all the different types of indexes? : Sql dba

1042

---

What is the difference between python and sql?

990

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2564

---

What is procedure explain with program?

1008

---

what's the difference between a primary key and a unique key? : Sql dba

1038

---