Re: SQLPLUS training, why?

  • From: Nuno Souto <dbvision@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 31 Dec 2010 14:23:00 +1100

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.



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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2010