upload text file to a database

[blessonin]

hi all,
i am new to oracle i want to know how to upload a file to a database and read the content of the file

[debasisdas]

You have two options for the same

1. Use sql loader to load the data from flat file to database.
2. Use external table.

[subashsavji]

 
create table demo
    ( id        int primary key,
      theClob    clob
    )
/
 
create or replace directory my_files as 'C:\';
/
 
 

 
CREATE OR REPLACE procedure load_a_file( p_id in number,
                        p_filename in varchar2 )
 as
     l_clob    clob;
     l_bfile    bfile;
 begin
     insert into demo values ( p_id, empty_clob() )
     returning theClob into l_clob;
     l_bfile := bfilename( 'MY_FILES', p_filename );
     dbms_lob.fileopen( l_bfile );
     dbms_lob.loadfromfile( l_clob, l_bfile,
                            dbms_lob.getlength( l_bfile ) );
     dbms_lob.fileclose( l_bfile );
 end;
/
 
EXECUTE load_a_file(2,'YY.TXT');
/
 
 

[subashsavji]

Use Sql Loader
You Will Get This Programm Easily In Sql Volume Ii Certification Book.