Answer Posted / guest

If new table is not yet created,
create table new_table as select * from old_table;

if new table is already created,
insert into new table select * from old_table
provided the structure of the new table is same as old
table.

What is scalar data type in pl sql?

1019

---

Can we rollback truncate?

944

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1089

---

How do you update a table in sql?

925

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

990

---

what is datawarehouse? : Sql dba

952

---

What is sql engine in oracle?

927

---

How do I start sql from command line?

962

---

Is record in oracle pl sql?

902

---

What does count (*) do in sql?

952

---

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

937

---

Mention what are the benefits of pl/sql packages?

1000

---

Does truncate table reset auto increment?

939

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1001

---

What is pl sql script?

976

---