CREATE DIRECTORY DIR1 AS 'd:\data';
CREATE TABLE filetable(id NUMBER(6),filename bfile);
INSERT INTO filetable VALUES (1,BFILENAME('DIR1','sunil.dat'));
select * from filetable;

desc scott.emp;
Name                           Null     Type
------------------------------ -------- -----------------------
EMPNO                          NOT NULL NUMBER(4)
ENAME                                   VARCHAR2(10)
JOB                                     VARCHAR2(9)    
MGR                                     NUMBER(4)
HIREDATE                                DATE           
SAL                                     NUMBER(7,2)
COMM                                    NUMBER(7,2)
DEPTNO                                  NUMBER(2)
8 rows selected

1562,'Sunil','hr',101,sysdate,17000,120,40

load data
infile 'd:\sunil.csv'
into table scott.emp
fields terminated by "," optionally enclosed by '"'		  
( EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO);

Error starting at line 1 in command:
load data
Error report:
Unknown Command

Error starting at line 2 in command:
infile 'd:\sunil.csv'
Error report:
Unknown Command

Error starting at line 3 in command:
into table scott.emp
Error report:
Unknown Command

Error starting at line 4 in command:
fields terminated by "," optionally enclosed by '"'		  
Error report:
Unknown Command

Error starting at line 5 in command:
( EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
Error at Command Line:1 Column:2
Error report:
SQL Error: ORA-00928: missing SELECT keyword