RE: set command

From: Kevin Lange <kgel_at_ppoone.com>
Date: Mon, 10 Jun 2002 11:18:25 -0800
Message-ID: <F001.00479401.20020610111825@fatcity.com>

You can also add
  set feedback off
This will stop any row counts from appearing at the end of the query.

Plus you can
  set sqlprompt ''
This will change the standard SQL> prompt to nothing. This way the SQL> that returns at the end of the query . Its anoying .

-----Original Message-----
Sent: Monday, June 10, 2002 12:58 PM
To: Multiple recipients of list ORACLE-L

set pagesize 0 as well, that stops the heading lines from breaking up your output

• Paula_Stankus_at_doh.state.fl.us wrote:
  > set linesize alone doesn't help - but will try it with set trimspool
  >
  > -----Original Message-----
  > Sent: Monday, June 10, 2002 12:48 PM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > Oracle doesn't place anything. SQL*Plus does.
  > If you generate scripts from SQL*Plus:
  > set linesize ...
  >
  > --
  > Alexandre
  >
  > ----- Original Message -----
  > To: Multiple <mailto:ORACLE-L_at_fatcity.com> recipients of list
  > ORACLE-L
  > Sent: Monday, June 10, 2002 3:58 PM
  >
  >
  > Guys,
  >
  > Building scripts from SQL generating SQL in Oracle on Unix. I know
  > that
  > there are set commands so that Oracle does not put CR or LF in the
  > middle of
  > a long command. Does anyone know these off the top of their head?
  >
  > Thanks,
  > Paula
  >
  > set array...?
  > set maxdata...?
  >
  >
  

  ---

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Lange
  INET: kgel_at_ppoone.com

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 Mon Jun 10 2002 - 14:18:25 CDT