Re: SQLPLUS question - SQL*Plus: Release 10.2.0.4.0
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Mon, 24 Aug 2009 14:53:22 -0500
Message-Id: <20090824195322.F3E261BF297_at_ws1-10.us4.outblaze.com>
oh, sorry.Try: SET SQLBLANKLINES on and then your sql scripts: Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsprodban:SQL> select sysdate
2
prodban:SQL> from dual;
SP2-0042: unknown command "from dual" - rest of line ignored. prodban:SQL> set sqlblanklines on
prodban:SQL> select sysdate
2
3 from dual;SYSDATE
24-AUG-09prodban:SQL>
HTH,Lyall
Date: Mon, 24 Aug 2009 14:53:22 -0500
Message-Id: <20090824195322.F3E261BF297_at_ws1-10.us4.outblaze.com>
oh, sorry.Try: SET SQLBLANKLINES on and then your sql scripts: Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsprodban:SQL> select sysdate
2
prodban:SQL> from dual;
SP2-0042: unknown command "from dual" - rest of line ignored. prodban:SQL> set sqlblanklines on
prodban:SQL> select sysdate
2
3 from dual;SYSDATE
24-AUG-09prodban:SQL>
HTH,Lyall
- Original Message ----- From: "Roger Xu" To: "Lyall Barbour" Cc: oracle-l_at_freelists.org Subject: Re: SQLPLUS question - SQL*Plus: Release 10.2.0.4.0 Date: Mon, 24 Aug 2009 14:28:01 -0500
It's not a problem not a inconvenience. We have a couple of BI
developers who sent me SQL scripts with a blank line between lines. I
have to take out them before I can run the script. SQL> !cat
/tmp/test.sql
select tablespace_name from dba_tablespaces where tablespace_name =
'SYSAUX';SQL> _at_/tmp/test.sql
SP2-0734: unknown command beginning "from dba_t..." - rest of line
ignored.
SP2-0734: unknown command beginning "where tabl..." - rest of line
ignored.
SQL>
On Mon, Aug 24, 2009 at 2:16 PM, Lyall Barbour <lyallbarbour_at_sanfranmail.com>
wrote:
it looks like sql*plus is doing exactly what it's supposed to by your example... >.> Can you detail out your problem a little more?Lyall
- Original Message ----- From: "Roger Xu" To: oracle-l_at_freelists.org Subject: SQLPLUS question - SQL*Plus: Release 10.2.0.4.0 Date: Mon, 24 Aug 2009 14:03:19 -0500
Hi Experts, In my SQL*Plus session, if I press Enter twice,
it goes back to the prompt. How do I change this kind of
behavior? SQL> select tablespace_name
2 from dba_tablespaces
3 where tablespace_name = 'SYSAUX';TABLESPACE_NAME
------------------------------
SYSAUXSQL> select tablespace_name
2
SQL> l
1* select tablespace_name Thanks, Roger Xu
- Be Yourself _at_ mail.com Choose From 200+ Email Addresses Get a Free Account at www.mail.com!
-- Be Yourself _at_ mail.com! Choose From 200+ Email Addresses Get a Free Account at www.mail.com! -- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 24 2009 - 14:53:22 CDT