what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

Does varchar need length?

0 Answers  

---

define sql update statement ? : Sql dba

0 Answers  

---

write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,

---

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

---

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

What is the difference between subquery and correlated query?

0 Answers  

---

What is the benefit of foreign key?

0 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

How many sql commands are there?

0 Answers  

---

What does count (*) mean?

0 Answers  

---

Explain constraints in sql?

0 Answers  

---