top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to create and load oracle tables from Excel sheet?

0 votes
417 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?

...