Answer Posted / raghunanda

---With date from existing table to new table.
SQL> create table new_table_name as select * from old_table_name where 1=1;
---without data
SQL> create table new_table_name as select * from old_table_name where 1=2;

Thanks,

List the ways to get the count of records in a table?

900

---

What is a sql select statement?

1030

---

what is a relationship and what are they? : Sql dba

1089

---

Which normal form is best?

946

---

How do you concatenate in sql?

1021

---

What is the use of function "module procedure" in pl/sql?

1189

---

What is cursor and its types?

1057

---

Explain the uses of a database trigger?

1031

---

Is it important to partition hard disk?

1022

---

What is the location of pre_defined_functions.

1162

---

Why is a primary key important?

1036

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1632

---

What are reports usually used for?

1017

---

What is break?

1188

---

what are string data types? : Sql dba

1036

---