Red-Database-Security GmbH is specialized in Oracle SecurityProductsRepscan 2.5 Hedgehog Enterprise Checkpwd (free)
Services
Information
Company |
Run OS commands via create table Requirements
For security reasons the preprocessor option does not allow the usage of |, < , >, &, and $ characters due to security reasons. Code: SQL> create or replace directory exec_dir as 'C:\WINDOWS\system32'; SQL> create or replace directory load_dir as 'C:\TOOLS'; SQL> create or replace directory log_dir as 'C:\TOOLS'; SQL> CREATE TABLE ADDRESS( "NAME" VARCHAR2(60)) ORGANIZATION EXTERNAL( TYPE oracle_loader DEFAULT DIRECTORY load_dir ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE PREPROCESSOR exec_dir:'gunzip' OPTIONS ' -d' BADFILE log_dir: 'address.bad' LOGFILE load_dir: 'address.log' FIELDS TERMINATED BY '|' MISSING FIELD VALUES ARE NULL ( "NAME" ) ) LOCATION ('address.txt.gz')) REJECT LIMIT UNLIMITED; SQL> select count(*) from ADDRESS; © 2009 by Red-Database-Security GmbH - last update 20-apr-2009 |