Re: SQLPLUS question - SQL*Plus: Release 10.2.0.4.0

From: Roger Xu <wellmetus_at_gmail.com>
Date: Mon, 24 Aug 2009 14:28:01 -0500
Message-ID: <eb64345d0908241228u43c27045h82e9e8256f819af6_at_mail.gmail.com>

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
> ------------------------------
> SYSAUX
> SQL> 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!
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 24 2009 - 14:28:01 CDT