top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How to create and load oracle tables from Excel sheet?

0 votes
89 views
How to create and load oracle tables from Excel sheet?
posted Aug 19, 2014 by Joshva

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

create table emp_ext (
EMPNO NUMBER(4),
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2))
Organization external
(type oracle_loader
default directory testdir
access parameters (records delimited by newline
fields terminated by ?,?)
location (?emp_ext.csv?))
reject limit 1000;

answer Sep 1, 2014 by Rathi
Similar Questions
+2 votes

I have an excel sheet to be upload on oracle and so that data can be access with SQL commands.
Please suggest some opinions...

+1 vote

Do i need to write in PL/SQL or is it possible in SQL query?

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...