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 -----------------------------------------------------------------