Need code to learn from

[Guest_imported]

Does anybody have any PL/SQL code that is used in real life they could send me? I'm trying to learn the language and am curious to see what the non-textbook code looks like.
My home address is granzow@home.com
Thanks, Mindy

 

[badco]

One simple example using a cursor and loop:


--THIS WILL GIVE YOU THE FIRST FIVE RECORDS
--FROM COLUMN MGR IN TABLE EMPY.
declare
m_id number;
cursor par is select mgr from empy;
begin
open par;
fetch par into m_id;
while (par%rowcount <= 5)
loop
dbms_output.put_line('mgr = ' || m_id);
fetch par into m_id;
end loop;
end;
/