Hello,<br>
<br>
I need to append a flat text file into an existing Oracle table. The data would be going into two columns. Can I do this with SQL or will I need to use PL/SQL? Any coding help will be appreciated.<br>
<br>
TIA,<br>
<br>
Bob
Bob,<br>
<br>
SQLLDR (SQL Loader) would be a good choice here for loading rows into a table from a text file. This is a standard Oracle utility and is quite easy to configure from the documentation.<br>
<br>
Drop us a line again if you have problems with it and I'll dig up my previous efforts to give you a head start.<br>
<br>
Mike<br>
---<br>
Mike_Lacey@Cargill.Com<br>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.