Re: SQLPLUS question - SQL*Plus: Release 10.2.0.4.0
- From: "Lyall Barbour" <lyallbarbour@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 24 Aug 2009 14:53:22 -0500
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@xxxxxxxxxxxxx
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> @/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@xxxxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
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 @ mail.com
Choose From 200+ Email Addresses
Get a Free Account at www.mail.com!
--
Be Yourself @ mail.com!
Choose From 200+ Email Addresses
Get a Free Account at www.mail.com!
Other related posts:
