Re: Retrieving LONG column through SQL *Plus.

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/07/11
Message-ID: <8kehtv$16kg$1@s2.feed.news.oleane.net>#1/1

here an example:

v734> desc dba_views

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 VIEW_NAME                       NOT NULL VARCHAR2(30)
 TEXT_LENGTH                              NUMBER
 TEXT                                     LONG

v734> set long 10000
v734> select text from dba_views where view_name='DBA_VIEWS';

TEXT

---

select u.name, o.name, v.textlength, v.text from sys.obj$ o, sys.view$ v, sys.user$ u where o.obj# = v.obj#
  and o.owner# = u.user#

1 row selected.

--
Have a nice day
Michel


<psunil_at_my-deja.com> a écrit dans le message : 8kcuch$sdc$1_at_nnrp1.deja.com...


> I wanted to retrive the data from table through SQL *Plus. My table has

> one LONG type column. When retrieved, it shows some arbitrary data for

> that column.

> How to get correct, readable data for LONG columns through SQL *Plus ?

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Tue Jul 11 2000 - 00:00:00 CDT