How do I insert a flat file created in Access into an Oracle9i database table, or can I use a function or write code for it to point to Oracle?
If it's a flat file, you can load it into Oracle in one of several ways:
1) With SQL*Loader,
2) using an externally defined table,
3) or using UTL_FILE to read the file and load its contents via PL/SQL.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.