Re: How to convert LONG to VARCHAR2

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 13 Apr 2013 00:16:36 -0300
Message-ID: <CAJdDhaN6+z7fxurHJL9osPsnE7sLH0PMQB4hhLMTkB8Ubunrmw_at_mail.gmail.com>

Hi People.
Thanks a lot for attention and solutions... I got sucess doing it:

1.) create a table with datatype varcha2 like this:

create table teste
(table_name VARCHAR2(30),
 COLUMN_NAME VARCHAR2(30),
 DATA_DEFAULT VARCHAR2(4000)); BEGIN
     for r in (select table_name , column_name , data_default from user_tab_columns
where table_name = 'THE_TABLE_NAME' and column_name = 'THE_COLUMN_NAME') loop

          INSERT INTO teste (table_name, column_name, data_default)
          values (r.table_name, r.column_name, r.data_default);
       end loop;

END;
/

Thanks and Regards
Eriovaldo

On Fri, Apr 12, 2013 at 5:05 PM, Sayan Malakshinov <xt.and.r_at_gmail.com>wrote:

> Just one note: dbms_xmlgen.getXMLtype truncates "LONG" columns to 4000
> bytes, although it works fine with clob
>
>
> --
> Best regards,
> Sayan Malakshinov
> Senior performance tuning engineer
> PSBank
> http://orasql.org
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 13 2013 - 05:16:36 CEST