Answer Posted / sivadasan

I think simply we can do like the following..

1. First we have to transfer all data from a table to
temporary table

create table Temp_table as select * from original_table;

2. Delete all record from Original Table....

delete original_table;

3. Now we can write a query by using INSERT and UNION

If any issue let me know....

insert into original_table (select * from temp_table
UNION select * from UNION )

Explain the methods used to protect source code of pl/sql.

1022

---

What is the sql*loader? : aql loader

1056

---

how to check myisam tables for errors? : Sql dba

1321

---

how to show all tables with 'mysql'? : Sql dba

1118

---

What is an exception in pl/sql?

1091

---

What is application trigger?

1002

---

Explain what is dbms?

1071

---

Which sorts rows in sql?

1023

---

What is %s in sql?

1032

---

What is partition by in sql?

1070

---

What is the difference between sql and t sql?

1042

---

What are the different types of functions in sql?

1055

---

How do temporal tables work?

964

---

What is sql select statement?

1035

---

How can we implement rollback or commit statement in a trigger?

1041

---