|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 23rd, 2004, 01:47 PM
|
|||
|
|||
How to import data into an Oracle table from text file
How to with PL/SQL code and oracle forms not to use sqlldr to import data into an Oracle table from (tab delimited
text file )? Last edited by pabloj : September 25th, 2004 at 05:30 PM. Reason: Added a descriptive subject
|
|
#2
September 24th, 2004, 05:06 AM
|
|||
|
|||
|
Use UTL_File package.Its the simplest way and quite good too. Only problem is you would have to keep the file at your database server if thats ok
Write a subroutine to read the file . Read the file you want to upload using Utl_file operations The delmiter can be used as chr(9) for tab delimited Form the sql statement within the code and then fire it within the sql code itself using Execute immediate. We have a generalized routine for this at our end and it works perfectly. I know you would have to take some carefull look in case of special chars like ' and & but hope you can manage  Cheers Santosh
|
|
#3
September 25th, 2004, 05:32 PM
|
||||
|
||||
|
You can also look at external tables
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > plzzzzzzzzzzzzzzz help urgent |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
