| How to check if column has value for LONG datatype? [message #370237] |
Fri, 16 April 1999 11:24  |
cmao
Messages: 3
Registered: April 1999
|
Junior Member |
|
|
|
I need to select records are not null or not empty using SQL select statement . The column has LONG datatype. . The user can accidently put the Tab or white spaces and save into the column. Therefore, the column will not be null but with "something" there. I can use " columnA IS NOT NULL" to check if columnA is null or not, and it works okay. However, how do I check if columnA is has actual values?
|
|
|
|
|
|
|
|
| Re: How to check if column has value for LONG datatype? [message #370240 is a reply to message #370239] |
Wed, 21 April 1999 10:45  |
Eric
Messages: 78
Registered: April 1999
|
Member |
|
|
I looked 'long' up in my documentation and this is what I found:
LONG columns can store text, arrays of characters, or even short documents. You can reference LONG columns in UPDATE, INSERT, and (most) SELECT statements, but not in expressions, SQL function calls, or certain SQL clauses such as WHERE, GROUP BY, and CONNECT BY.
Is the data in these columns possibly small enough to use varchar2 instead of long?
good luck!
Eric
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
