question about reading text files from sql/pl 2.2 
Author Message
 question about reading text files from sql/pl 2.2

Hi there,

How can i read data from a text file and put it into a oracle table?

I only have pl/sql 2.2.2.3.0

thanks a lot

Juan Durn

Sent via Deja.com http://www.***.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 question about reading text files from sql/pl 2.2

Hi there,

How can i read data from a text file and put it into a oracle table?

I only have pl/sql 2.2.2.3.0

thanks a lot

Juan Durn

Sent via Deja.com http://www.deja.com/
Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 question about reading text files from sql/pl 2.2
Use SQL*Loader.

HTH,
Brian

Quote:

> Hi there,

> How can i read data from a text file and put it into a oracle table?

> I only have pl/sql 2.2.2.3.0

> thanks a lot

> Juan Durn

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 question about reading text files from sql/pl 2.2
It depends on the format of the text file and your OS. If you don't have
loader you can still write perl/unix scripts to build and execute
sqlplus insert statements.

Darren

Quote:

> Hi there,

> How can i read data from a text file and put it into a oracle table?

> I only have pl/sql 2.2.2.3.0

> thanks a lot

> Juan Durn

> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
***********************************************
  Darren Brock   Oracle Developer/DBA
  Governet
  208-522-1225

***********************************************


Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. read text-file in pl/sql

2. Reading from a text file and writing toa text file from Vis Bas 6.0

3. Creating Fixed-Record Length Text File - PL/SQL Command File

4. PL/SQL file deletion / dir read

5. WebDb 2.2 Dynamic html pages parameters question

6. Read Client File using OAS 3.0&PL/SQL

7. Can PL/SQL Read Indexed Files?

8. SQL*Net 2.2 and SQL*Net 2.3 compatibility ?

9. Read Client File using OAS 3.0 and PL/SQL

10. PL/SQL: Reading/Writing to a file

11. read ASCII file in PL/SQL

12. Question on FAQ item 2.2


 
Powered by phpBB® Forum Software