Oracle Notepad Editor Customization in Windows

What is a Notepad editor?

Windows Notepad is a simple text editor for Microsoft Windows and a basic text-editing program which enables computer users to create documents. Notepad is a text editor, i.e., an app specialized in editing plain text. It can edit a text file and the file name extension is .txt.

Notepad is used when writing and saving commands of PL/SQL codes for the purpose of easy an environment of saving, exit and run.   Save at an editor again and again.

          Customize your windows on your laptop-

1.      Go to C:\oraclexe

2.      Press Right button->Properties->Security-> Click on Full Control->Click on Edit-> Give Tick on Full Control-> Click on Apply-> Click on Ok Button

3.      Go to the command prompt window by typing cmd from desktop search

4.      Login by your user name and password

5.      Open notepad by SQL> ed rose

6.      Write SQL or PL/SQL at your opened notepad rose

7.      Save it and exit to command prompt

8.      Run the notepad file from SQL prompt by writing @ rose and enter

9.      Your SQL or PL/SQL is run and view your expected output at SQL> prompt

10.   Again, open the notepad file by SQL> ed rose

11.   Repeat again and again.

Code writing practice in Notepad can be done in the following manner shown in table-

Function	Command
SQL Write	Sql> ed rose Save exit
SQL Run	Sql> @ rose View desired output at the screen
Clear Screen	Sql>cl scr;

The writer is oracle certified professional. The writer can be reached at rashid.eee.cse@gmail.com

www.rashid-bd.info