Answer Posted / prabha

Distinct:
Its gives only the non duplicate values in a database table.
Unique:
The UNIQUE constraint uniquely identifies each record in a
database table.its similar to primary key.these values
cannot be repeated.

Can triggers stop a dml statement from executing on a table?

1036

---

What are the set operators in sql?

1036

---

What does sign mean sql?

1030

---

What is asqueryable?

907

---

Can we insert data in view?

898

---

How to change the order of columns in Oracle SQL Plus ?

1004

---

What is bind variable in pl sql?

988

---

How do you add a column to a table?

1004

---

How do you rename a table in sql?

1041

---

what is the difference between delete and truncate statement in sql? : Sql dba

1142

---

Explain the types of joins in sql?

970

---

Explain what is a subquery ?

1130

---

Describe different types of general function used in sql?

986

---

What is sql comments?

1042

---

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

1547

---