EXTERNAL TABLE


External table geçici olarak tablo yaratma işlemlerinde kullanılır.

SQL > CREATE DIRECTORY emp_dir AS ’/flat_files’ ;

SQL > CREATE TABLE oldemp (
empno NUMBER, empname CHAR(20), birthdate DATE) ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER DEFAULT DIRECTORY emp_dir ACCESS PARAMETERS
(RECORDS DELIMITED BY NEWLINE BADFILE ’bad_emp’
LOGFILE ’log_emp’
FIELDS TERMINATED BY ’,’ (empno CHAR,
empname CHAR,
birthdate CHAR date_format date mask "dd-mon-yyyy")) LOCATION (’emp1.txt’))
PARALLEL 5
REJECT LIMIT 200; Table created.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: