Ads Top

How to run a pl/sql program -Steps of running of pl/sql program

How to begin

Step-1

Type 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:

Touchfeeds. Powered by Blogger.