Home » Infrastructure » Unix » Displaying LONG Type columns using SQL
Displaying LONG Type columns using SQL [message #162135] Wed, 08 March 2006 22:26 Go to next message
raom
Messages: 22
Registered: January 2006
Location: india
Junior Member
Hi
can any body please suggest solution.
i have a table tab1 with three columns.

COLUMN TYPE
NBR1 NUMBER
INDEX NUMBER
BITMAP LONG

i wanted to display the value BITMAP couldn't
i am gettin some junk r nothing.
with this this query
SELECT * FROM TAB1;
Re: Displaying LONG Type columns using SQL [message #162166 is a reply to message #162135] Thu, 09 March 2006 00:49 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
If the value is being truncated, use
SET LONG 65536
before you run your SQL in SQL*Plus.
_____________
Ross Leishman
Re: Displaying LONG Type columns using SQL [message #162198 is a reply to message #162166] Thu, 09 March 2006 02:58 Go to previous message
raom
Messages: 22
Registered: January 2006
Location: india
Junior Member

but this is what i am gettin.though i do set long 65536
BITMAP
--------------------------------------------------------------------------------
À
À
À
À
À
À
À
À
À
À
À

BITMAP
--------------------------------------------------------------------------------
À
À
À
À
À
À
À
À
À
À
À

Previous Topic: Redirect to the same file
Next Topic: How to create partition for RAW disk devices of specific sizes
Goto Forum:
  


Current Time: Thu Mar 28 12:57:39 CDT 2024