Re: SQLPLUS training, why?

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@xxxxxxxxxxxx



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 @'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 (@) 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


Other related posts: