Usage of Long Datatype !! Urgent!!!!!

[ramuganapathi]

Hi,

I have a table which has a column of type Long. This column has some values. I need to query those rows which are matching with the text in the Long Datatype column.

Can anybody help me in this regard!!, its urgent

Regards
Ramu Ganapathi

[JChiappa]

First things firstly : ** IF ** you are using Oracle db version 8.x OR greater , THEN you must STOP the usage of LONGs - plain & simple. LONGs are UN-MANAGEABLE in SQL , implies in performance penalties - mainly because row chaining ...
Anyway : if you want manipulate and/or search LONGs, you must do it in another languages (forget pure SQL), you can do it in PL/SQL (directly using LONG variables if your LONG column < 32 Kb, OR reading by chunks using DBMS_SQL), or pro*c, or Java...

[]s

Chiappa