CIS4365: Database Applications
Fall, 2017

Getting Started with SQL*PLUS

Return to Home Page

For access into ORACLE , you must have an Oracle account. I will send you one (via Email) both on Omega and Oracle. If you do not have an Oracle account, you must get one.

Note: most of these slides (in a better viewable form) are also available from the Lecture slide Page.

Log onto your Oracle account (in the Calc Lab) by clicking on the start button (lower left-hand corner) and selecting Oracle.

Enter your Username, password and Host String( 08ibegin.utep.edu: NOTE the string starts with an 'o' as in Oracle, NOT '0' (zero))

You have done everything correctly if you have seen the following screen:

You can enter single-line or multiple-line SQL statement. An SQL statement is not case-sensitive. To end a SQL statement and execute, you can do it in one of the two ways:

·   end with a semicolon;  
·   end with a slash / on a line by itself   

 

  This page was last updated on 08/24/03.