Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

COPYING CONTENTS OF .CSV TO ORACLE DATA BASE USING SQLPLUS

Sreelatha PragadapatiNov 30 2016 — edited Nov 30 2016

Hi All...

I want to export data from csv file to oracle database table using COPY command of SQLPLUS..please help...

i could login to database using the below

c:\>sqlplus username/password@host:port/servicename

then iam saying

copy SRC from 'c:\xxx\src.csv'   --where SRC is table name

please tell me the correct way of using copy command on sqlplus command prompt...

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 28 2016
Added on Nov 30 2016
9 comments
1,675 views