Where can I find PLSQL samples?

[ProgrammingB52]

Does anyone have a link for any PLSQL samples that I can run?

 

[SantaMufasa]

Sure, B52. What types of programming examples would you like to see? Well try to provide examples similar to your need.

Perhapse the easiest environment from which to run blocks of PL/SQL code is simply SQL*Plus. Here are a couple of examples, including "The World's Shortest PL/SQL Example" and a sample script that shows how to output from a PL/SQL block:

begin null; end;
/

PL/SQL procedure successfully completed.
(Doesn't success feel good?)

set serveroutput on
begin
    dbms_output.put_line('The current date and time is: '||
        to_char(sysdate,'yyyy-mm-dd "@" hh24:mi:ss'));
end;
/
The current date and time is: 2005-05-11 @ 10:42:06

PL/SQL procedure successfully completed.

So, the above are examples of "working" PL/SQL blocks, but there are some excellent PL/SQL books available, as well.

Let us know more about your need and wants.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.