How to ignore the title of the first row in an oracle External table
Introduction
When an oracle External table references a csv or other txt file, you often want to skip the title of the first line. In fact, when creating an oracle External table, you can useSkip 1The specific syntax is as follows.
Note: In the following code, skip 20 indicates that the first 20 rows are ignored. You can also change the value to any integer based on your needs. Generally, the title of the second row is ignored.
Create table dept_external (deptno NUMBER (6), dname VARCHAR2 (20), loc VARCHAR2 (25 )) organization external (TYPE oracle_loader default directory admin access parameters (records delimited by newline BADFILE 'ulcase1. bad 'discardfile' ulcase1. dis 'logfile' ulcase1. log 'skip 20 fields terminated by "," optionally enclosed by '"' (deptno integer external (6), dname CHAR (20), loc CHAR (25 ))) LOCATION ('ulcase1. ctl ') reject limit unlimited;