may i have a SIMPLE and COMPLETE PL/sql program?

please!!can you give me a pl/sql program!!Hello,

which program do you need ? What should it do ?

Here is a Hello world program as an anonymous block ..

BEGIN
DBMS_OUTPUT.PUT_LINE("Hello World");
END;

But I think this example wont help ..

Pls specify your request.

Best regards
Manfred Peter
Alligator Company Software GmbH
http://www.alligatorsql.com|||a program that contains control statements such as if else, exception handling. its better if compute for something!!thanks!!!i really need a running program!!!|||Originally posted by tinchua84
a program that contains control statements such as if else, exception handling. its better if compute for something!!thanks!!!i really need a running program!!!
You could try the sample code from the PL/SQL manual:

http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/appdev.920/a96624/a_samps.htm#2644sql