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
Printable View
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
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