Answer Posted / sivadasan

Sorry for the previous answer....

We can do like this ,

1. First we have to transfer all data from original_table
table to a 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

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

any issues let me know.....

What is a table?

982

---

How insert into statements in sql?

1027

---

What are different sql data types?

989

---

How to select unique records from a table?

1018

---

What is the difference between the conventional and direct path loads? : aql loader

1349

---

Is join and inner join the same?

960

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3962

---

Does sqlite need a server?

1013

---

explain normalization concept? : Sql dba

1013

---

what is index? : Sql dba

966

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1559

---

What is sql injection owasp?

1023

---

What is a column in a table?

1084

---

what are the advantages a stored procedure? : Sql dba

945

---

Can we use joins in subquery?

1110

---