AIL PROTECTED]
> > 11/26/2002 07:54 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
>
> <[EMAIL PROTECTED]>
>
> > cc:
> > Subject:RE: LONG's
> >
> >
EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 11/26/2002 07:54 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:RE: LONG's
>
>
>
> Thanks all for th
Sorry I missed 2nd part of Ur question.
LOB is not a datatype it self. LOB = Long Object.
Oracle provides 2 kind of LOBs. CLOB and BLOB
If U want to store Binary data, eg pdf files, movies,
sound files, etc, use BLOB(Binary long Object).
For other U can use CLOB.
OraCOp.
--- VIVEK_SHARMA <[EMA
U can use To_LOB(long_col) to convert long to
Clob/BLOB.
OraCop
--- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote:
>
> How may LONG , LON RAW be Converted to CLOB or LOB ?
> Which is Better ?
>
> Thanks
>
> -Original Message-
> Sent: Tuesday, November 26, 2002 9:24 PM
> To: Multiple recipi
nts of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: LONG's
How may LONG , LON RAW be Converted to CLOB or LOB ?
Which is Better ?
Thanks
-Original Message-
Sent: Tuesday, November 26, 2002 9:24 PM
To: Multiple recipients of list ORACLE-L
Thanks all for
ase respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: LONG's
Thanks all for the suggestions. I think I'll take a look at COPY and the
PL/SQL options since I've used them before, and C &a
How may LONG , LON RAW be Converted to CLOB or LOB ?
Which is Better ?
Thanks
-Original Message-
Sent: Tuesday, November 26, 2002 9:24 PM
To: Multiple recipients of list ORACLE-L
Thanks all for the suggestions. I think I'll take a look at COPY and the
PL/SQL options since I've used t
Thanks all for the suggestions. I think I'll take a look at COPY and the
PL/SQL options since I've used them before, and C & Perl are not in my
repertoire, I'm ashamed to say ;) To shed a little more light on the
requirement, I'm researching the best (subjective) way to convert
dictionsry-manage
you can use the copy command for the longs - but I don't think it
works for long raws - write a pl/sql that pulls it in in 32k chunks or create
temp tables with the pk and long raw and do the insert/update
routine.>>> [EMAIL PROTECTED] 11/25/02 09:59AM
>>>
OK, so
you can't CTAS on tables wi
Mike,
Conner pointed out that you could use C.
You can also use Perl with DBI and DBD::Oracle if you like, and have
someone there that can use it.
Why not just convert them to CLOB and LOB?
Jared
"Hand, Michael T" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/25/2002 07:59 AM
Please
Mike,
You could look at the COPY command - provided you don't mind the table name
changing or living in a different schema. I guess you could do a copy and
then an alter table ... rename command.
The syntax for the copy command is along the lines of:
copy from user/pass@sid to user/pass@sid cre
Its called the C compiler :-)
If the LONG's are not so long (ie less than 32k) you
can get away with just plain old static PLSQL to get
at the data, otherwise you can look at dbms_sql
hth
connor
--- "Hand, Michael T" <[EMAIL PROTECTED]> wrote: >
OK, so you can't CTAS on tables with LONG or LON
12 matches
Mail list logo