Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Script and control file
Andrea,
Is this UNIX or NT.
In UNIX ( I don't know NT that well), the most simple method would be to use a shell script.
The following is about as basic as it comes but would need to be embellished with environment settings and error checking etc..
eg.
Start of Script
sqlplus username/passwd <<EOF
create table TABLE1
( col1,
col2.....);
exit;
EOF
sqlldr <parameters>
sqlplus username/password <<EOF2
select .... from TABLE1
where (.............);
exit;
EOF2
End of Script
Regards
Lee
-----Original Message-----
Sent: 29 May 2001 16:16
To: Multiple recipients of list ORACLE-L
First of all, I'm a beginner to SQL/SQL Loader.
Currently,I'm working with Oracle 8.
I would like to know if it's possible invoke SQL Loader inside a script.
Example:
- inside the script I want to create a new table TABLE1 - copy some data inside TABLE1 using SQL loader - work on TABLE1 using SQL language.
Is it possible do this inside a .sql file ?
Thanks,
Andrea
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Quaglio Andrea
INET: Andrea.Quaglio_at_semagroup.it
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
INET: lerobe_at_acxiom.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 29 2001 - 11:10:17 CDT