Thursday, May 13, 2010

Hello PL/SQL

--Started learning PL/SQL using this simple undaunting tutorial.

declare
luckynbr number(2);
abcdate date;

begin
select sysdate into abcdate from dual;
select dbms_random.value(0,100) into luckynbr from dual;

dbms_output.put_line('Your lucky number on ' || abcdate || ' is ' || luckynbr );

end;
/

No comments:

Post a Comment