SQL*Plus is an Oracle client -- a command-line application that allows the user to query and administer a database and its tables.

The user enters SQL (Structured Query Language) commands (or statements), the standard language for RDBMSes.

Different RDBMSes have different "flavors" or variations of standard SQL, but the basics are pretty much the same for all. MS Access even allows you to create queries in a "SQL View".

When entering commands and statements:

- extra white space is ignored
- statements may span multiple lines (by hitting Enter)
- the command is submitted only when it ends with a semi-colon, followed by hitting Enter
- statements are not case sensitive; case only matters when referring to field values in WHERE clauses.

In the lab:

- Launch the application from:

Start > All Programs > Oracle > OraHome92 > Application Development > SQL Plus

- Both your account User Name and Password are your first initial and your full last name.
- The Host String is orgis

You can copy text from Notepad (or any other document) and paste it into the SQL*Plus window.

You can copy what appears in the SQL*Plus window and paste it into Notepad or Word, etc.

There is no way to retrieve previous statements with the "up arrow" in this particular version of SQL*Plus, but you can resubmit the last statement by entering the forward slash ( / ) character. You can view your previous statement by entering the letter "L".

Sample commands: