Answer / Jayveer Singh

To create a new table by selecting rows from another table, you can use the Create Table As Select (CTAS) statement. Here's an example:nn`CREATE TABLE new_table AS SELECT * FROM existing_table;`

How to Select second Maximum salary in a Table ?

13 Answers   Oracle,

---

What is a proxy class?

1 Answers  

---

Explain view?

1 Answers  

---

Define oracle database

1 Answers  

---

"primary key=unique+null" is equal,reson?not,reason?

5 Answers  

---

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 Answers   HCL, IBM,

---

How to set a transaction to be read only in oracle?

1 Answers  

---

master table and child table performances and comparisons in Oracle ?

1 Answers  

---

What is redo log?

1 Answers  

---

does Oracle has only one table space?

1 Answers   Oracle,

---

How to find the duplicate rows count from employees table in oracle?

1 Answers  

---

How to connect asp pages to oracle servers?

1 Answers  

---