Thanks for your reply. I am new to Oracle database. Is there any pre-defined packages/functions?
You can define the table as an External table so long as the CSV file is on the database server. From there, you can access the data with a standard SELECT on the external table.
Otherwise, you have to load the file's contents into Oracle. You can use SQL Developer as thatJeffSmith-Oracle has indicated. The wizard will walk you through the process. Otherwise, you can use the SQL*Loader command line utility to load the contents into a table.
Is there any pre-defined packages/functions?
Oracle does not have any predefined package to do import a CSV file into a table.