Re: Character Set Problems

From: Carlos <miotromailcarlos_at_netscape.net>
Date: Thu, 14 Jun 2007 06:16:46 -0700
Message-ID: <1181827006.098093.220000@z28g2000prd.googlegroups.com>

On 14 jun, 14:46, Paul <paulwragg2..._at_hotmail.com> wrote:
> Sorry but you can't use DUMP on a LONG column!
>
> Thanks anyway.

I know, but if you can do it in this way:

We'll take dba_views which has a LONG column (TEXT):

carlosal_at_bd01.xxxxxxxx> CREATE TABLE MY_DBA_VIEWS 2 AS SELECT

  3  OWNER            OWNER           ,
  4  VIEW_NAME        VIEW_NAME       ,
  5  TEXT_LENGTH      TEXT_LENGTH     ,
  6  TO_LOB(TEXT)     TEXT            ,           <--NOTE THIS!!
  7  TYPE_TEXT_LENGTH TYPE_TEXT_LENGTH,
  8  TYPE_TEXT        TYPE_TEXT       ,
  9  OID_TEXT_LENGTH  OID_TEXT_LENGTH ,
 10  OID_TEXT         OID_TEXT        ,
 11  VIEW_TYPE_OWNER  VIEW_TYPE_OWNER ,
 12  VIEW_TYPE        VIEW_TYPE       ,

13 SUPERVIEW_NAME SUPERVIEW_NAME
14 FROM DBA_VIEWS; Tabla creada.

carlosal_at_bd01.xxxxxxxx> DESC MY_DBA_VIEWS Nombre ¿Nulo? Tipo

-------- --------------- OWNER NOT NULL VARCHAR2(30) VIEW_NAME NOT NULL VARCHAR2(30) TEXT_LENGTH NUMBER TEXT CLOB <--NOTE THIS!! TYPE_TEXT_LENGTH NUMBER TYPE_TEXT VARCHAR2(4000) OID_TEXT_LENGTH NUMBER OID_TEXT VARCHAR2(4000) VIEW_TYPE_OWNER VARCHAR2(30) VIEW_TYPE VARCHAR2(30) SUPERVIEW_NAME VARCHAR2(30)

carlosal_at_bd01.xxxxxxxx> SELECT DUMP(TO_CHAR(TEXT)) FROM MY_DBA_VIEWS WHERE ROWNUM < 2;

DUMP(TO_CHAR(TEXT))

Typ=1 Len=160:
115,101,108,101,99,116,32,34,76,73,66,95,73,68,88,34,44,34,76,73,66,95,78,65,77...

HTH Cheers.

Carlos. Received on Thu Jun 14 2007 - 08:16:46 CDT