RE: SQL generating SQL - stupid question continued lines
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Aug 2004 10:11:19 -0400
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@xxxxxxxxxxxxxxx [mailto:Paula_Stankus@xxxxxxxxxxxxxxx]
Sent: Friday, August 20, 2004 9:53 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Jared.Still@xxxxxxxxxxx
Sent: Thursday, August 19, 2004 1:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: SQL generating SQL - stupid question continued lines
oracle-l-bounce@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
