Re: SQLPLUS question - SQL*Plus: Release 10.2.0.4.0

Raj

On Mon, Aug 24, 2009 at 3:28 PM, Roger Xu <wellmetus_at_gmail.com> wrote:

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

-- 
-----
Best regards
Rjamya

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