Re[2]: SQL generating SQL - stupid question continued lines
- From: Jonathan Gennick <jonathan@xxxxxxxxxxx>
- To: Paula_Stankus@xxxxxxxxxxxxxxx
- Date: Thu, 19 Aug 2004 18:17:59 -0400
Hello Paula,
You might look into the command SET SQLBLANKLINES ON, which
enables SQL*Plus to deal with blank lines in the midst of
SQL statements.
Best regards,
Jonathan Gennick --- Brighten the corner where you are
http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx
Join the Oracle-article list and receive one
article on Oracle technologies per month by
email. To join, visit http://five.pairlist.net/mailman/listinfo/oracle-article,
or send email to Oracle-article-request@xxxxxxxxxxx and
include the word "subscribe" in either the subject or body.
Thursday, August 19, 2004, 12:08:25 PM, Paula_Stankus@xxxxxxxxxxxxxxx
(Paula_Stankus@xxxxxxxxxxxxxxx) wrote:
Pdsfu> Guys,
Pdsfu> I hope you don't mind answering this - I am sure I answered this at one =
Pdsfu> time but now forgot the answer.
Pdsfu> I have some SQL generating SQL but there are skipped lines so the =
Pdsfu> commands do not look correct and I get=20
Pdsfu> SP2-....unknown command.
Pdsfu> What is the set command to change this behavior?
Pdsfu> Thanks,
Pdsfu> Paula
Pdsfu> ----------------------------------------------------------------
Pdsfu> Please see the official ORACLE-L FAQ: http://www.orafaq.com
Pdsfu> ----------------------------------------------------------------
Pdsfu> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
Pdsfu> put 'unsubscribe' in the subject line.
Pdsfu> --
Pdsfu> Archives are at //www.freelists.org/archives/oracle-l/
Pdsfu> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
Pdsfu> -----------------------------------------------------------------
----------------------------------------------------------------
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:
- » Re[2]: SQL generating SQL - stupid question continued lines
