This content has been marked as final. Show 6 replies
yes, you can use options in editors like toad / sql developer
Toad again uses SQL*LDR. Is there other utility other than the 2 options that I have mentioned?
What is the problem with SQL*Loader and/or external tables that you would hope some other tool would provide? There are any number of ELT tools on the market, for example, that can load data from a flat file. You can use database links to load data from other databases (Oracle and non-Oracle). You can use the export and import utilities (preferrably the DataPump versions) to move data between Oracle databases. Without knowing what problem you are trying to solve, though, it's impossible to guess whether this is helpful to you or not.
Apologize for not providing the details.
I was just curious to know if there are other options.
SamFisher wrote:There are many ways to read data.
Are there any other options other than SQL*LDR & External tables to load external data in ORCL?
SQL*Loader is an external command line utility
External Tables are an internal mechanism that using the same 'engine' as the SQL*Loader utility, in order to be able to read data as if it's on a table already (hence it can be used through SQL).
You could also use the UTL_FILE package to read files line-wise or byte-wise as a low level mechanism.
Also, methods such as BFILE reading as demonstrated... ( goes off to find an example ).... here:
There are also other built in packages that contain procedures/functions that offer some form of file reading and writing.
And you can also create your own using Java in the database.
So, take your pick... lots to choose from... and it all depends what you want to do.
Thank You all.