Re: select on LONG!

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Wed, 1 Sep 1999 11:37:41 +0200
Message-ID: <7qis6e$4ea$1@oceanite.cybercable.fr>

Yes, it is possible to select long in SQL*Plus. See the following query (columns text of dba_views is LONG):

set long 10000
select text from dba_views where view_name='ALL_ARGUMENTS'; TEXT

---

select
u.name, /* OWNER */
nvl(a.procedure$,o.name), /* OBJECT_NAME */ decode(a.procedure$,null,null, o.name), /* PACKAGE_NAME */ o.obj#, /* OBJECT_ID */
decode(a.overload#,0,null,a.overload#), /* OVERLOAD */

a.argument, /* ARGUMENT_NAME */
a.position, /* POSITION */
a.sequence#, /* SEQUENCE */
a.level#, /* DATA_LEVEL */

decode(a.type, /* DATA_TYPE */

0, null,
1, 'VARCHAR2',
2, decode(a.scale, null, decode(a.precision, null, 'NUMBER', 'FLOAT'),'NUMBER'),

3, 'NATIVE INTEGER',

8, 'LONG',
9, 'VARCHAR',

12, 'DATE',
23, 'RAW',
24, 'LONG RAW',
29, 'BINARY_INTEGER',
69, 'ROWID',
96,'CHAR',
102, 'REF CURSOR',
105, 'MLSLABEL',
106, 'MLSLABEL',
250, 'PL/SQL RECORD',

251, 'PL/SQL TABLE',
252, 'PL/SQL BOOLEAN',
'UNDEFINED'),
default$, /* DEFAULT_VALUE */
deflength, /* DEFAULT_LENGTH */
decode(in_out,null,'IN',1,'OUT',2,'IN/OUT','Undefined'), /* IN_OUT */ length, /* DATA_LENGTH */
precision, /* DATA_PRECISION */
scale, /* DATA_SCALE */
radix /* RADIX */
from obj$ o,argument$ a,user$ u
where o.obj# = a.obj#
and o.owner# = u.user#
and (owner# = userenv('SCHEMAID')
or exists
  (select null from v$enabledprivs where priv_number in (-144,-141)) or o.obj# in (select obj# from sys.objauth$ where grantee# in   (select kzsrorol from x$kzsro) and privilege# = 12))

1 row selected.

Doktor a écrit dans le message <37CCE057.DEAB960A_at_post.pl>...
>It's impossibile to select LONG datatype in SQL*Plus. If you selecting
>LONG column into variable, remember, that you can use only 32K of data
>for variables.
>
>Michel Cadot wrote:
>>
>> I think you make the query with SQL*Plus, so try:
>> Set LONG 10000
>> and you will get the entire text.
>> The defaut for LONG parameter is 80 characters
>> that is you get only the first 80 characters of LONG field.
>>
>> Nandakumar a écrit dans le message <7qhmgq$dmn$1_at_nnrp1.deja.com>...
>> >When i do a select on a field of LONG datatype, only a part of its value
>> >is selected or displayed. Can someone say how to get the full value
>> >displayed?
>> >
>> >For instance, users_triggers table has a LONG field called TRIGGER_BODY.
>> >when i select this field for one of my triggers, an incomplete
>> >definition appears as shown here.
>> >--
>> >BEGIN
>> >update nanda.agent set user_number = (select user_number from www.users
>> >w
Received on Wed Sep 01 1999 - 04:37:41 CDT