RE: set command

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Mon, 10 Jun 2002 11:58:26 -0800
Message-ID: <F001.0047951B.20020610115826@fatcity.com>

Setting SQLPROMPT to '' is very handy, but there is one caveat. After the query executes, SQL*Plus 'appears' to hang because there is no prompt to indicate where the next command is to be entered(like SET PAUSE ON and forgetting about it...d'oh).

I spooled as much as 10,000 characters on a single line without problem. However, there is a limit of 2500 characters for the command line and the LINESIZE is platform dependent.

Do you have an example we could chew on?

Daniel W. Fink
Sr. Oracle DBA
MICROMEDEX
303.486.6456

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

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fink, Dan
  INET: Dan.Fink_at_mdx.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:58:26 CDT