What is SQL Loader?
Source: http://www.orafaq.com/wiki/SQL*Loader_FAQ
SQL*Loader is a bulk loader utility used for moving data from external files into the [[Oracle database]]. Its syntax is similar to that of the [[DB2]] load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads.
Data can be modified as it is insert by using the decode command: http://www.orafaq.com/wiki/SQL*Loader_FAQ#Can_one_modify_data_as_the_database_gets_loaded.3F
Decode is like and if-then-else command.
http://techonthenet.com/oracle/functions/decode.php
No comments:
Post a Comment