Can anyone let me know how to upload a flat-file without using SQL*loader or external table in oracle database?
Like is there any function available in oracle to complete this task?
Please let me know the different ways to upload flat files apart from SQL*loader and External table.
Advertisement
Answer
You could write a PL/SQL program which will use UTL_FILE, read contents of that file and insert rows into some table. You’ll have to talk to DBA to create a directory, grant read/write privileges on it to you (i.e. user which will load data), possibly grant execute on UTL_FILE (again to you).
Another option – if there’s Apex (Oracle Application Express) installed on that database – is to create a load data set of pages (don’t worry, you don’t have to do anything, the Wizard will create everything for you). I don’t know what’s in the background – maybe it is SQL*Loader, can’t tell, but – you wouldn’t be “explicitly” using it, but do everything in GUI.