Re: Query a Long Type

In article <2t4p5p$d0o_at_mystech.mystech.com> jcrupi_at_mystech writes:
>Is there any way to query against a Long type ?
>

The answer is, of course, YES. Therefore, I assume there is something not

included in your question.                                                 
                                                                           
The SQL statement                                                          
                                                                           
         select A from B;                                                  
                                                                           

will return the value of column A from all rows in table B. If you were to issue the command in SQL*Plus, and column A is defined as LONG, you will see the first 80 characters of column A. If there are more characters, you need to reset the default length for LONG datatypes.

If you issue the SQL*Plus command:

         set LONG 500

and then issue the original SQL command, you will see characters 81 thru 500. [Note: If the value you set for LONG is too large, Oracle will indicate a space problem. If I remember correctly, the error message tells you what parameter to reset.]

If you are using some tool other than SQL*Plus, it may have inherent limitations for handling LONG datatype columns. It all depends on the tool.

Good luck

-- 
============================================================================
Michael Sallwasser  | Down one path is utter dispair and hopelessness. Down 
Northrop Grumman    | the other is total destruction. Let us choose wisely.
============================================================================