How to run a pl/sql program -Steps of running of pl/sql program
How to begin
Step-1Type set serveroutput on in the sql command like below in the picture and press enter key .
Step-2
Type filename of the program along with .sql and press enter key .
Step-3
Its open a notepad file that named by you .Type the program and press the close button .Then its ask you to save or not .just press save and close.
Step-4
After saving the program type get filename.sql in the sql command and press enter key .
Step-5
Type / (backslash) and press enter key .then enter your output values.If you have any errros in the program again type ed filename.sql and change the errors and again run the program in the above mentioned way.
Step-6
After running the program press exit to cancel the sql or close the sql command .
No comments: