Re: SQLPLUS question - sqlblanklines & sqlcase

Thank you! I also found the following useful.

SQL> set sqlcase mixed
SQL> select tablespace_name from dba_tablespaces where tablespace_name =
'sysaux';
no rows selected
SQL> set sqlcase upper
SQL> select tablespace_name from dba_tablespaces where tablespace_name =
'sysaux';
TABLESPACE_NAME
------------------------------
SYSAUX


On Mon, Aug 24, 2009 at 2:53 PM, Lyall Barbour <lyallbarbour@xxxxxxxxxxxxxxx
> wrote:

> 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
> options
> prodban: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-09
> prodban: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
>> ------------------------------
>> SYSAUX
>> SQL> 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:

  • » Re: SQLPLUS question - sqlblanklines & sqlcase - Roger Xu