I am pretty new to Oracle, but recently
done courses in PL/SQL, still finding my way around.
I need to automate a task to load data
into an oracle table from a csv file.
I know about SQLloader, but I need to run the task automatically based on a scheduled date and time. How can I achieve this. Is it also possible to write a PL/SQL program to do the same.
Please suggest the best solution to get the job done and sample code/instructions.