Demonstrate a simple External table : Create Table « Table « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Table
  3. Create Table
SQL>
SQL> create directory external_tables as 'C:\Oracle\oradata\external';

Directory created.

SQL>
SQL>
SQL> -- Create the external table:
SQL> create table student_emails_ext
  2   (id         char,
  3   firstname    varchar(40),
  4    lastname     varchar(40),
  5    email        varchar(80) )
  6  organization external
  7  (
  8    type oracle_loader
  9    default directory external_tables
 10    location ('students_test.txt')
 11  ) reject limit unlimited
 12  /

Table created.




SQL>
SQL>
SQL>
SQL> drop directory external_tables;

Directory dropped.

SQL>
SQL>
SQL> drop table student_emails_ext;

Table dropped.








6.1.Create Table
6.1.1.Creating a Table
6.1.2.Create table with storage setting
6.1.3.Create table with storage setting 2
6.1.4.Create an external table
6.1.5.Create copy table
6.1.6.Create a table from one or more other tables
6.1.7.Rename a table
6.1.8.One column with three constraints
6.1.9.Use referencing columns
6.1.10.Create a table based on a hash cluster
6.1.11.Create table with 'organization index OVERFLOW'
6.1.12.Create table with 'organization index'
6.1.13.Cascade delete setting
6.1.14.Demonstrate a simple External table
6.1.15.Create intermediate table for calculation
6.1.16.Make myCode a CACHE table.