Question Hello Edson,
I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table.
Can you guide me how to do this???
Answer Hi there.
There are some good ways to do it. The simplest way is to use a interface, just like PL/SQL Developer or SQL Navigator. This applications have a import suite. In PL/SQL developer it is in tools --> import file.
If you donīt have the possibility to use this applications, so you should think about SQL Loader. Itīs Oracleīs import tool.
The last tip would be to use utl_file and utl_raw. But specifically in this case you will have to create a directory in oracle. ASk your DBA the possibility of creating one.
See the best option and mail me back. So we star with the chosen.
