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;

Explain the advantages and disadvantages of stored procedure?

1197

---

Explain two easy sql optimizations.

1070

---

What is rank function in sql?

1067

---

Write a query to find the names of users that begin with "um" in sql?

1039

---

Can ddl statements be used in pl/sql?

1186

---

What is the difference between distinct and unique in sql?

988

---

How to download oracle sql developer?

1161

---

How can you know that statistics should be updated?

1125

---

What is the difference between inner join and outer join?

1035

---

What is use of trigger?

982

---

explain the difference between bool, tinyint and bit. : Sql dba

1057

---

what is the syntax for using sql_variant_property? : Transact sql

1079

---

Can delete statement be rollbacked?

1029

---

Which operator is used in query for pattern matching?

1126

---

What is sql in java?

1131

---