PROTECTED] On Behalf Of Tanel
Poder
Sent: Thursday, September 11, 2003
9:40 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: (long and boring)
converting long to lob - the easiest and fastest way ?
Hm, yep, it seems it works only in
insert select command (I tried an update with subquery
OTECTED]
>
>
>
>-Original Message-
>
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Siddharth Haldankar
>
>Sent: Thursday, September 11, 2003
>3:44 PM
>
>To: Multiple recipients of list
>ORACLE-L
>
>Subject: converting long to lob -
>
hes, that way
you'll save disk space (if you grow your table to 2X it's size, there's no way
to reduce it without reorganization).
Cheers,
Tanel.
----- Original Message - From:
Siddharth Haldankar To: Multiple recipients of list ORACLE-L Sent:
Thursday, September 11, 2003
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Siddharth Haldankar
Sent: Thursday, September 11, 2003
3:44 PM
To: Multiple recipients of list
ORACLE-L
Subject: converting long to lob -
the easiest and fastest way ?
Hi Gurus,
How do I convert a long
datatype to clob datatype.
Say
]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tanel
Poder
Sent: Thursday, September 11, 2003
4:59 PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: converting long to
lob - the easiest and fastest way ?
Sorry, I didn't notice in the end of your
nkar
To: Multiple recipients of list ORACLE-L
Sent: Thursday, September 11, 2003 1:14
PM
Subject: converting long to lob - the
easiest and fastest way ?
Hi
Gurus,
How do I convert a long datatype to clob
datatype.
Say Table A
No
tiple recipients of list ORACLE-L
Sent: Thursday, September 11, 2003 1:14
PM
Subject: converting long to lob - the
easiest and fastest way ?
Hi
Gurus,
How do I convert a long datatype to clob
datatype.
Say Table A
No
number
Hi
Gurus,
How do I convert a long datatype to clob datatype.
Say Table A
No number
Col1 long
Would like to convert to
Table A
No number
Col1 clob
Alter table A modify (col1 clob);
Gives an error as inco