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.

Can you select everything, but 1 or 2 fields, without writer's cramp?

691

---

What is the difference between a primary key and a clustered index?

697

---

what are the features and advantages of object-oriented programming? : Sql dba

727

---

How to select all records from the table?

804

---

What is the meaning of disabling a trigger?

826

---

---

Explain exception handling in pl/sql?

727

---

What do you know by pl/sql cursors?

759

---

What is pl sql package?

797

---

discuss about myisam key cache. : Sql dba

763

---

How to use transactions efficiently : transact sql

770

---

What is an oracle stored procedure?

784

---

how many groups of data types? : Sql dba

728

---

What is rtm in testing?

764

---

Can I join the same table twice?

747

---

Explain mutating table error.

840

---