Message-Id: <10652.119426@fatcity.com> From: "SAURY Alain" Date: Tue, 17 Oct 2000 10:16:17 +0200 Subject: RE: How to convert LONG into LOB ???? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C03812.85C57150 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Starting with 8.1.5 you can use the TO_LOB function that converts a = LONG RAW to a LOB. However it has limitations : it think it can only be used within a = INSERT SELECT command. Alain -----Message d'origine----- De: Helmut Daiminger [SMTP:hdaiminger@vivonet.com] Date: mardi 17 octobre 2000 02:05 =C0: Multiple recipients of list ORACLE-L Objet: How to convert LONG into LOB ???? Hi! I got two tables that have LONG and LONG RAW datatypes in them. a) since we are running 8i, it would make sense to convert them to LOB columns, eh? Since we store pictures in those columns, BLOB would be ok, eh? b) how do I move existing data from the original table to the new table (with LOB column)? This is 8.1.6 on Win2k. Thanks, Helmut SQLWKS> desc TABLE1; Column Name Null? Type ------------------------------ -------- ---- EVENTICONID NOT NULL NUMBER(38) DESCRIPTION VARCHAR2(50) USERID NUMBER(38) ICON LONG RAW DOCUMENTID NUMBER(38) STATUS CHAR(2) SQLWKS> desc TABLE2; Column Name Null? Type ------------------------------ -------- ---- SQLID NOT NULL NUMBER(38) SQLSCRIPT LONG DOCUMENTID NUMBER(38) DESCRIPTION VARCHAR2(50) STATUS CHAR(2) --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author: Helmut Daiminger INET: hdaiminger@vivonet.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C03812.85C57150 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable RE: How to convert LONG into LOB ????

Starting with 8.1.5 you can use the = TO_LOB function that converts a LONG RAW to a LOB.
However it has limitations=A0: it = think it can only be used within a INSERT SELECT command.

Alain