Topics: Hands-On 02 - Notepad Editing
Oracle makes provisions for you to utilize your favorite text editor to edit
the statement created in "afiedt.buf," the file into which SQL*PLUS stores
the most recently executed SQL statement.
You simply type edit (abbreviated "ed").
This action causes Oracle to bring up the SQL statement in "afiedt.buf" into
the operating system's default text editor.
To change the text editor, issue the define_editor='your editor' statement
from the SQL*PLUS prompt.
Try to use a text editor rather than the Command Line editor.
Manuscript
Go to MS-DOS and change the directory to the iself folder.
>> cd ..\iself
Login to “sqlplus” as "iself/schooling".
>> sqlplus iself/schooling
Get the dept file.
>> get dept
Your default editor is notepad.
Use the "ed" command, to call
notepad.
On notepad, you can modify the query.
Then close the window and click on Yes to replace the changes to the buffer.
Click on the “NO” button, since it is very easy.
Let’s not spend too much time on that.
===
Another technique you may want to use is to open the notepad as an independent
tool.
Open the dept script from the iself directory.
Open notepad as a separate window.
===
Open the "dept" file from the "iself"
folder.
===
Add a column heading.
Change the statement to query only the department number 10.
Save the file.
Save the file at the iself folder.
Go to SQLPLUS
Go to “SQLPLUS.”
Get the "dept" file.
>> get dept
Notice that the changes are in the buffer, run the query.
>>run
Use the “Start” command to run the query.
Go to notepad
Remove the department number column.
Save the changes.
Go back to “SQLPLUS.”
Use the @ sign to run the file.
No department number this time.
Now, you should practice this over and over, until you become a master at it.
Good Luck!