| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL generating SQL - stupid question continued lines
Reminds me of my first job using a card punch to send our programs to the
computer. Someone would need the JCL to do something, and my manager would
say "I have a car deck that does that". He would hand us the JCL deck and
say "put your cards right here and then give me this card deck back". He
had no idea what all the JCL was doing - but he had a deck that worked, and
woe anyone who returned the cards back to him in the wrong order.
Ahh, those were the days.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Paula_Stankus_at_doh.state.fl.us [mailto:Paula_Stankus_at_doh.state.fl.us]
Sent: Friday, August 20, 2004 9:53 AM
To: oracle-l_at_freelists.org
Subject: RE: SQL generating SQL - stupid question continued lines
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
-- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 09:07:06 CDT
 |
 |