Answer Posted / lakshmikanthan

while using where or order by clause in long datatype column . error will come LIKE
ORA-00997: illegal use of LONG datatype .

And another points is :
1. only one long data type allowed in a table
2. cannot able to create the constraint in a long data type column in a table
error :
ORA-02269: key column cannot be of LONG datatype.

What is before trigger?

550

---

explain about mysql and its features. : Sql dba

543

---

How many subqueries can be nested in a statement?

503

---

Can we have two clustered index on a table?

562

---

What is the use of double ampersand (&&) in sql queries? Give an example

609

---

---

Mention what does plv msg allows you to do?

662

---

How many sql commands are there?

673

---

how to convert numeric values to character strings? : Sql dba

566

---

how to calculate expressions with sql statements? : Sql dba

525

---

What are all the ddl commands?

626

---

What is an example of translating a date into julian format?

575

---

What is a call statement? Explain with an example.

545

---

Is not equal in sql?

562

---

What is not equal in sql?

509

---

What is percent sign in sql?

713

---