Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL generating SQL - stupid question continued lines

RE: SQL generating SQL - stupid question continued lines

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Fri, 20 Aug 2004 09:53:27 -0400
Message-ID: <80D4A99A2715674EB2D256DAD89219F6044E8C3F@dohsmail02.doh.ad.state.fl.us>


Thanks Jared.=20

I understand after X many years of this - saying - it works - I forgot = why but it works. =20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared.Still_at_radisys.com
Sent: Thursday, August 19, 2004 1:38 PM
To: oracle-l_at_freelists.org
Subject: RE: SQL generating SQL - stupid question continued lines

oracle-l-bounce_at_freelists.org wrote on 08/19/2004 09:08:25 AM:
> Guys,

>=20
> I hope you don't mind answering this - I am sure I answered this at =
one=20
=3D
> time but now forgot the answer.

>=20

> I have some SQL generating SQL but there are skipped lines so the =3D
> commands do not look correct and I get=3D20
>=20

Here is the std settings I use for this:

set pause off
set echo off
set trimspool on
set echo off verify off

clear col
clear break
clear computes

btitle ''
ttitle ''

btitle off
ttitle off

set pages 0 lines 200 term on feed off head off

Don't ask why b/ttitle are set to a blank and then turned off: I don't remember.

Jared



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


BEGIN-ANTISPAM-VOTING-LINKS
------------------------------------------------------
Teach CanIt if this mail (ID 7674447) is spam:
Spam:        =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D7674447&m=3D32268=
1f3071b
Not spam:    =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D7674447&m=3D32268=
1f3071b
Forget vote: =
https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D7674447&m=3D32268=
1f3071b
------------------------------------------------------
END-ANTISPAM-VOTING-LINKS

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Aug 20 2004 - 08:50:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US