RE: SUPPRESS SQL STATEMENTS
I run the following script, and the -S option solved the problem I had (I even had the line # out in the script and re-invoked it). If the username/pw is on a separate line as shown below, the ps command does not display the userid/pw info. # Set environment variables#!/bin/ksh # Set local environment variablesORACLE_BASE=/opt/oracleJOBDATE=`date '+%Y%m%d'`; export JOBDATE;JOBTIME=`date '+%H%M'`; export JOBTIME; sqlplus -S EOFusername/[EMAIL PROTECTED]set echo offrest of script EOF[EMAIL PROTECTED] wrote: what are the limitations? other than ps commands that can read past a 3k command line "Norris, Gregory T [ITS]" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 12:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SUPPRESS SQL STATEMENTSTrue, but last I checked it had a number of limitations... it's basically a band-aid, while the patient is hemorrhaging. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SUPPRESS SQL STATEMENTSnot a pr! oblem on most *nix if you use hide.c http://www.cybcon.com/~jkstill/util/zips/hide.tgz Jared "Norris, Gregory T [ITS]" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 06:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]cc:Subject:RE: SUPPRESS SQL STATEMENTSOn *nix systems, the username/password information will be visible to all via the "ps" command. Not good.-Original Message-Sent: Tuesday, October 14, 2003 11:09 AMTo: Multiple recipients of list ORACLE-LDon't run the script while you're inside sqlplus. Run it from outside:sqlp! lus un/pw @your-script-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Norris, Gregory T [ITS]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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 mayalso send the HELP command for other information (like subscribing).
RE: SUPPRESS SQL STATEMENTS
I usually do echo passwd | sqlplus -s [EMAIL PROTECTED] Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Johan Muller [mailto:[EMAIL PROTECTED]Sent: Thursday, October 16, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SUPPRESS SQL STATEMENTS I run the following script, and the -S option solved the problem I had (I even had the line # out in the script and re-invoked it). If the username/pw is on a separate line as shown below, the ps command does not display the userid/pw info. # Set environment variables#!/bin/ksh # Set local environment variablesORACLE_BASE=/opt/oracleJOBDATE=`date '+%Y%m%d'`; export JOBDATE;JOBTIME=`date '+%H%M'`; export JOBTIME; sqlplus -S EOFusername/[EMAIL PROTECTED]set echo offrest of script EOF[EMAIL PROTECTED] wrote: what are the limitations? other than ps commands that can read past a 3k command line "Norris, Gregory T [ITS]" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 12:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SUPPRESS SQL STATEMENTSTrue, but last I checked it had a number of limitations... it's basically a band-aid, while the patient is hemorrhaging. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SUPPRESS SQL STATEMENTSnot a pr! oblem on most *nix if you use hide.c http://www.cybcon.com/~jkstill/util/zips/hide.tgz Jared "Norris, Gregory T [ITS]" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 06:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:Subject: RE: SUPPRESS SQL STATEMENTSOn *nix systems, the username/password information will be visible to all via the "ps" command. Not good.-Original Message-Sent: Tuesday, October 14, 2003 11:09 AMTo: Multiple recipients of list ORACLE-LDon't run the script while you're inside sqlplus. Run it from outside:sqlp! lus un/pw @your-script-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Norris, Gregory T [ITS]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (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 mayalso send the HELP command for other information (like subscribing).**This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**5
RE: SUPPRESS SQL STATEMENTS
On *nix systems, the username/password information will be visible to all via the ps command. Not good. -Original Message- Sent: Tuesday, October 14, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Don't run the script while you're inside sqlplus. Run it from outside: sqlplus un/pw @your-script -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: SUPPRESS SQL STATEMENTS
not a problem on most *nix if you use hide.c http://www.cybcon.com/~jkstill/util/zips/hide.tgz Jared Norris, Gregory T [ITS] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 06:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SUPPRESS SQL STATEMENTS On *nix systems, the username/password information will be visible to all via the ps command. Not good. -Original Message- Sent: Tuesday, October 14, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Don't run the script while you're inside sqlplus. Run it from outside: sqlplus un/pw @your-script -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: SUPPRESS SQL STATEMENTS
True, but last I checked it had a number of limitations...it's basicallya band-aid,while the patient is hemorrhaging. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SUPPRESS SQL STATEMENTSnot a problem on most *nix if you use hide.c http://www.cybcon.com/~jkstill/util/zips/hide.tgz Jared "Norris, Gregory T [ITS]" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 06:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SUPPRESS SQL STATEMENTSOn *nix systems, the username/password information will be visible to all via the "ps" command. Not good.-Original Message-Sent: Tuesday, October 14, 2003 11:09 AMTo: Multiple recipients of list ORACLE-LDon't run the script while you're inside sqlplus. Run it from outside:sqlplus un/pw @your-script-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Norris, Gregory T [ITS]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: SUPPRESS SQL STATEMENTS
what are the limitations? other than ps commands that can read past a 3k command line Norris, Gregory T [ITS] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 12:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SUPPRESS SQL STATEMENTS True, but last I checked it had a number of limitations... it's basically a band-aid, while the patient is hemorrhaging. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 15, 2003 2:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: SUPPRESS SQL STATEMENTS not a problem on most *nix if you use hide.c http://www.cybcon.com/~jkstill/util/zips/hide.tgz Jared Norris, Gregory T [ITS] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 06:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SUPPRESS SQL STATEMENTS On *nix systems, the username/password information will be visible to all via the ps command. Not good. -Original Message- Sent: Tuesday, October 14, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Don't run the script while you're inside sqlplus. Run it from outside: sqlplus un/pw @your-script -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: SUPPRESS SQL STATEMENTS
set head off message off feedback off echo off _ David Kurtz Go-Faster Consultancy Ltd. tel: +44 (0)7771 760660 fax: +44 (0)7092 348865 mailto:[EMAIL PROTECTED] web: www.go-faster.co.uk PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba -Original Message- Johan Muller Sent: 13 October 2003 17:49 To: Multiple recipients of list ORACLE-L A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as part of the formatting. Posssible solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Kurtz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: SUPPRESS SQL STATEMENTS
Don't run the script while you're inside sqlplus. Run it from outside: sqlplus un/pw @your-script -Original Message- Sent: Monday, October 13, 2003 12:49 PM To: Multiple recipients of list ORACLE-L A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as part of the formatting. Posssible solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: SUPPRESS SQL STATEMENTS
The script is run from a cron job with a ksh script calling the sql from outside sqlplus. I've solved the problem by using sed to cull the offensive lines, but I should be able to use sqlplus formatting statements to give the correct results. I did include message off (from a previous email), but the results remain the same sofar. --- Khedr, Waleed [EMAIL PROTECTED] wrote: Don't run the script while you're inside sqlplus. Run it from outside: sqlplus un/pw @your-script -Original Message- Sent: Monday, October 13, 2003 12:49 PM To: Multiple recipients of list ORACLE-L A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as part of the formatting. Posssible solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: SUPPRESS SQL STATEMENTS
Not recommended to include the password on the command-line -- you're then exposing it to other users (via ps, for example), particularly on UNIX systems. Adam Khedr, Waleed [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 10:09 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: SUPPRESS SQL STATEMENTS Don't run the script while you're inside sqlplus. Run it from outside: sqlplus un/pw @your-script -Original Message- Sent: Monday, October 13, 2003 12:49 PM To: Multiple recipients of list ORACLE-L A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as part of the formatting. Posssible solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: SUPPRESS SQL STATEMENTS
Use the silent option -S in sqlplus -Original Message- Sent: Tuesday, October 14, 2003 12:29 PM To: Multiple recipients of list ORACLE-L The script is run from a cron job with a ksh script calling the sql from outside sqlplus. I've solved the problem by using sed to cull the offensive lines, but I should be able to use sqlplus formatting statements to give the correct results. I did include message off (from a previous email), but the results remain the same sofar. --- Khedr, Waleed [EMAIL PROTECTED] wrote: Don't run the script while you're inside sqlplus. Run it from outside: sqlplus un/pw @your-script -Original Message- Sent: Monday, October 13, 2003 12:49 PM To: Multiple recipients of list ORACLE-L A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as part of the formatting. Posssible solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
RE: SUPPRESS SQL STATEMENTS
-Original Message- Johan Muller A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as part of the formatting. Posssible solutions? I'm not sure if this is answers your question, but is this the output you're looking for? # cat x.ksh sqlplus /nolog @x.sql # cat x.sql set echo off connect username/password spool x.lst select dummy from dual ; spool off exit # x.ksh SQL*Plus: Release 9.2.0.3.0 - Production on Tue Oct 14 11:51:35 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected. D - X Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production # cat x.lst D - X # -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: SUPPRESS SQL STATEMENTS
Start the script from another script? Johan Muller wrote: A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as part of the formatting. Posssible solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).