document updated 15 years ago, on Dec 9, 2009
- SQL*Plus is not NOT NOT designed to be useful from scripts.
- Nontheless, some people hack it...
- O'Reilly's book, chapter 9 ("Extracting and Loading Data") goes through a lot of the finer details
- fundamental constraint: max linesize is 32767 chars
- SQL*Loader can insert rows directly into a table
- there are various ways to accomplish "SQL*Unloader"