CS 471 Oracle User Account Login Information and Edit Command

Oracle 9i is provided for this class.

Every student must have an Oracle account, which is created by the Oracle administrator in the beginning of the semester. The username and password for accessing the account will be given to all Oracle account holders.

 

Login Information

1.     Click  Start® Programs® Oracle® OraHome81® Application Development® SQL plus

A window will appear prompting you to enter:

                        User Name:    <Enter your user name>

                        Password:       <Enter your password>

                        Host String:   orcl.kcsql2.kc.umkc.edu

2.     If you successfully login, you will be able to see an sql prompt (SQL>). You are now ready to start using sql.

Logout Information

SQL> exit

 

If you have any questions, send an e-mail to Shanthan Toodi at srt8rc@umkc.edu

 

Edit Command and afiedt.buf

AFIEDT.BUF is the SQL*Plus default edit save file. When you issue the command "ed" or "edit" without arguments, the last SQL or PL/SQL command will be saved to a file called AFIEDT.BUF and opened in the default editor.

To incorporate this facility in your Oracle account, do the following:

1. Set the path where you want this file to be created. At the SQL prompt type:

> set editfile "Y:/afiedt.buf";

This command will create file afiedt.buf in your Y: directory. This will allow you to use the edit command.

2. If you want it to be saved in a subdirectory, then specify the entire path and filename within quotes, in the above command.

An alternative to the above method, for editing SQL commands:

1. Using the mouse, select the command you want to edit from the SQL window. 
2. Paste it in notepad using Ctrl+v
3. Edit it
4. Select it again
5. Paste it at the SQL prompt using Ctrl+v
6. Press enter to execute it

 

 

Go to >> CS 431, CS470, CS471, CS 490BI, CS 570, CS572, CS670.