CODE EXAMPLE FOR SQL

To Create directory

C:>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 3 15:07:01 2013
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 - Production

SQL> create or replace directory MYCSV as 'e:mycsv';
Directory created.

SQL> grant read, write on directory MYCSV to scott;
Grant succeeded.