Re: LONG's

2002-11-28 Thread Jared Still
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 > > > >

Re: LONG's

2002-11-28 Thread Yechiel Adar
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

RE: LONG's

2002-11-26 Thread OraCop
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

RE: LONG's

2002-11-26 Thread OraCop
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

RE: LONG's

2002-11-26 Thread Jared . Still
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

RE: LONG's

2002-11-26 Thread Jared . Still
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

RE: LONG's

2002-11-26 Thread VIVEK_SHARMA
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

RE: LONG's

2002-11-26 Thread Hand, Michael 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

Re: LONG's

2002-11-26 Thread John Shaw
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

Re: LONG's

2002-11-25 Thread Jared . Still
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

Re: LONG's

2002-11-25 Thread Mark Richard
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

Re: LONG's

2002-11-25 Thread Connor McDonald
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