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;

What is benefit of creating memory optimized table?

972

---

What is dcl in sql?

960

---

How do I write a sql query in pgadmin 4?

983

---

What is the use of desc in sql?

977

---

Which sql statement is used to delete data from a database?

957

---

Explain how to use transactions efficiently : transact sql

980

---

What is informix sql?

976

---

Can cursors be part of a trigger body?

1641

---

how can we submit a form without a submit button? : Sql dba

986

---

What is tuple in sql?

1078

---

discuss about myisam index statistics collection. : Sql dba

951

---

How do I partition in sql?

963

---

What is procedure function?

1061

---

What is sql profiling in oracle?

1064

---

what is difference between delete and truncate commands? : Sql dba

1132

---