Answer Posted / john bershan

any number of null value can be inserted into table for a
column which is declared as unique.coz null vale s either
not equal to any value or not equal to another null;

How many tables can you join in sql?

958

---

Differentiate pl/sql and sql?

1071

---

What are the different dcl commands in sql?

1176

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582

---

What are the possible values that can be stored in a boolean data field?

1002

---

What are the different types of sql commands?

1128

---

Can we call a function containing dml statements in a select query?

981

---

What is before and after trigger?

963

---

Explain what is a database?

1087

---

What is informix sql?

983

---

What is pl sql variable?

995

---

What is a schema sql?

1159

---

Can variables be used in sql statements?

1036

---

What is a primary key example?

965

---

Is a secondary key the same as a foreign key?

1038

---