Answer Posted / smita

Hi,
No , we cant create pk eithout unique index it
implicitelygenerater by oracle.
I want to clear that pk can b on one or more col but only
one pk.
While unique constraint can b one or more col and can b one
or morn unique key in a table

Is sql free?

1022

---

Explain the difference between drop and truncate commands in sql?

1102

---

How to assign sql query results to pl sql variables?

1138

---

Can we use commit inside a trigger?

1140

---

How to read/write files from pl/sql?

1078

---

What is procedure and function in sql?

1042

---

What are triggers in sql?

1054

---

What is sql mysql pl sql oracle?

1122

---

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1116

---

What is the purpose of primary key?

1067

---

What are sql*plus environment variables?

1144

---

What is #table in sql?

1175

---

what are the advantages of sql ? : Sql dba

1105

---

How can we avoid duplicating records in a query?

1028

---

Explain how can you save or place your msg in a table?

1074

---