hello, PL/SQL

とりあえず。

set serveroutput on;
begin

  DBMS_OUTPUT.PUT_LINE('hello, PL/SQL');

end;

/

hello, PL/SQL

for文。

set serveroutput on;
declare

  cnt number;

  now date;

begin

  for cnt in 1..10 loop

    select sysdate into now from dual;

    DBMS_OUTPUT.PUT_LINE(cnt || ': ' || now);

  end loop;

end;

/

1: 2005-01-20 12:39:34

2: 2005-01-20 12:39:34

3: 2005-01-20 12:39:34

4: 2005-01-20 12:39:34

5: 2005-01-20 12:39:34

6: 2005-01-20 12:39:34

7: 2005-01-20 12:39:34

8: 2005-01-20 12:39:34

9: 2005-01-20 12:39:34

10: 2005-01-20 12:39:34