Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> NEWBIE: Trying to run an anonymous block (PL/SQL)

NEWBIE: Trying to run an anonymous block (PL/SQL)

From: Carlos Jose Guerrieri <carlos.guerrieri_at_realize-it.com>
Date: Tue, 18 Nov 2003 22:57:39 +0100
Message-ID: <bpe4sj$k00$07$1@news.t-online.com> 





Hi,



i`m new to PL/SQL. I bought the ORACLE PL/SQL book from Feuerstein and would
try to run some examples but i have my problems to get it run.
I tried the following anonymous block in TOAD and i get no output. Maybe
someone can figure out what i did wrong?



DECLARE



  today DATE DEFAULT SYSDATE;


BEGIN



  DBMS_OUTPUT.PUT_LINE ('Today is ' || today);
END;


I tried this also in SQL*PLUS but had no success too. It expect more input
(line) after the end-statement.



Thanks in advance


Carlos Jose Guerrieri
Received on Tue Nov 18 2003 - 15:57:39 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US