Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Text-file
From the sql manual:
CREATE TABLE emp_external (
employee_id NUMBER(6),
last_name VARCHAR2(20), email VARCHAR2(25), hire_date DATE, job_id VARCHAR2(10), salary NUMBER(8,2)
deptno INTEGER EXTERNAL, dname CHAR, loc CHAR
-- Terry Dykstra Canadian Forest Oil Ltd. "s Lehaire" <s.lehaire_at_meilleuregestion.com> wrote in message news:as5h8l$b9r$1_at_reader1.imaginet.fr... > > "s Lehaire" <s.lehaire_at_meilleuregestion.com> a écrit dans le message de > news: as55kv$78a$1_at_reader1.imaginet.fr... > > Hi, > > I know that is possible to write into a file the resultset of a query with > > the spool option. > > but is it possible to read a text file to put the data into a table ? > > Thx for response > > ++ > > > > > > Ok I found a solution but i've got a probleme: > I found the UTL_FILE package but I can't read my file because oracle is not > authorized to acces thie directory > so I must add this directory in the init.ora file config but I don't know > how to do. > please help =) > >Received on Thu Nov 28 2002 - 15:50:22 CST