Answer / pavan_1981

no its not possible to use long columns in WHERE or ORDERBY
clause.other restrictios on LONG column are
1.there can be only colum of long data type in a table.
2.no constraints can be defined on long column.
3.a long column will not be cpied when u create a new table
from existing table using a subquery.

Answer / 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.

Answer / bolearner

Long data type can't participate for any operation in SQL.

Only DML queries can be applied.

Can't apply any aggregate function on LONG colum.

Can't apply any analytical function on LONG colum.

Can apply sequence on LONG colum.

Can apply synonym for LONG column table.

Can create view for LONG column table and Mat view is not possible.

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 Answers  

---

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

How to avoid duplicate records in a query?

0 Answers  

---

Show the cursor attributes of pl/sql.

0 Answers  

---

how to retrive only second row from table?

31 Answers   IBM,

---

I want to know last five transactions or records from emp table, from now?

11 Answers   Wells Fargo,

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

what is the syntax used for partition in tsql? : Transact sql

0 Answers  

---

Is left join inner or outer?

0 Answers  

---

what is global variable in package

3 Answers   Polaris,

---