Create an external table : Create Table « Table « Oracle PL / SQL

Create an external table


SQL> create table myTable
  2  (c1 varchar2(80) )
  3  organization external
  4  (
  5   type oracle_loader
  6   default directory infile
  7   access parameters
  8      (
  9        records delimited by newline
 10        fields
 11        (c1 char(80) )
 12      )
 13   location ('xml.lst')
 14   )
 15  /

SQL> select * from myTable
  2  where rownum <= 5;

SQL> drop table myTable;


Related examples in the same category

1.Create table template
2.Create table with data type: VARCHAR2, Date, Number(8,2)
3.Using a CREATE TABLE statement: create a table with primary key
4.Creating Table with combined primary key
5.Create table with foreign key
6.Creating an index-organized table
7.create as select
8.create as select, then add primary key
9.CREATE TABLE AS SELECT with where clause
10.Creating Table and indicate tablespace
11.An example of creating an index-organized table:
12.Create a table with 'deferrable initially immediate'
13.include a complete CREATE INDEX clause as part of the CREATE TABLE statement
14.Create a table by specifying the storage settings
15.Create a table with ORGANIZATION INDEX
16.Use 'using index' option when creating a table
17.Create a table and set storage FREELISTS 2
18.Create a table with 'overflow INCLUDING y'
19.Create table with Check Constraints
20.Create table with Unique Constraints
21.Creating an External Table
22.A create-table statement with the attributes of ISBN, title, author, and publisher. The primary key is the ISBN attribute.
23.Create intermediate table for calculation
24.Create table with three columns