dbms_lob has all that you need to know and use.
Raj
--- Prem Khanna J <premj_at_rediffmail.com> wrote:
>
> hi all,
> oracle 9.2.04:
>
> SQL > DESC MYTAB1
> ----------
> MYCOL1 BLOB
> ....
>
> there will be either CSV files/plain text files stored
> in MYCOL1.i need to read this file and straight away
> insert each row in that file as a record in another
> table URTAB1.i need to do this in pl-sql.
>
> will DBMS_LOB help in this case ? any hint/sample
> code plz ?? nothing strikes my head !!
>
> Thanks and Regards,
> Prem.
Best Regards
Raj
select mandatory_disclaimer from company_requirements;
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Jul 14 2004 - 09:08:32 CDT
