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 )

How many types of primary keys are there?

1078

---

What is the starting oracle error number? What is meant by forward declaration in functions?

1041

---

What are all the ddl commands?

1241

---

Can you do multiple joins in sql?

1117

---

how to shutdown mysql server? : Sql dba

1144

---

Which command is used to delete a trigger?

1404

---

what is the difference between group by and order by in sql? : Sql dba

1185

---

how to run 'mysql' commands from a batch file? : Sql dba

1170

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1093

---

What is %type in pl sql?

1008

---

Can we connect to postgresql using sql developer?

1048

---

What is the difference between syntax error and runtime error?

1183

---

how to drop an existing view in mysql? : Sql dba

1104

---

what is try_catch block in procedure

1808

---

what is the use of set statement in tsql? : Transact sql

1059

---