| 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[2]: SQL generating SQL - stupid question continued lines
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@gennick.com
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_at_gennick.com and include the word "subscribe" in either the subject or body.
Thursday, August 19, 2004, 12:08:25 PM, Paula_Stankus_at_doh.state.fl.us (Paula_Stankus_at_doh.state.fl.us) 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_at_freelists.org Pdsfu> put 'unsubscribe' in the subject line. Pdsfu> -- Pdsfu> Archives are at http://www.freelists.org/archives/oracle-l/ Pdsfu> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html Pdsfu> -----------------------------------------------------------------Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
 |
 |