Re: SQLPLUS training, why?

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Fri, 31 Dec 2010 14:23:00 +1100
Message-ID: <4D1D4C94.8020709_at_iinet.net.au>

Thanks Norman. Yup, that's what I was asking, I wasn't very clear in my reply. Dang, I need to get Oracle into the new lappie urgently: millions of new things to try out. When I'm using the work servers it's usually too hectic to do any play around.

Happy 2011 everyone, while I'm here.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_iinet.net.au



Dunbar, Norman (Capgemini) wrote,on my timestamp of 31/12/2010 1:09 AM:


> And the answer (to Nuno's query) appears to be, yes!

>

> The following has been _at_'d (started) with sqlbl on and off and both

> times, it worked as expected:

>

> declare

>     vDummy varchar2(100);

>

> begin

>     select 'Hello World!'

>

>     into vDummy

>     from

>

>

>     dual;

>

>     dbms_output.put_line(vDummy);

> end;

> /

>

> I have also pasted it directly into sqlplus with sqlbl on and off, and

> again, both times, it worked as expected.

>

> The following was not so lucky:

>

>     select 'Hello World!'

>

>

>     from

>

>

>     dual;

>

> Starting (_at_) the file with sqlbl on, the result is as expected and with

> it off, the errors are:

>

> SP2-0042: unknown command "from" - rest of line ignored.

> SP2-0042: unknown command "dual" - rest of line ignored.

>

> Pasting the code directly into sqlplus gives the same results.

>


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

Received on Thu Dec 30 2010 - 21:23:00 CST