...
| No Format |
|---|
jaredg@atreides > setenv ORACLE_HOME /usr/oracle jaredg@atreides > sqlplus iepm@slacprod SQL*Plus: Release 10.1.0.5.0 - Production on Tue Nov 25 17:59:24 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning and Real Application Testing options SQL> |
The Invoking sqlplus command line is followed with done with the name of the command, a space, the database username, currently iepm, an at sign, and then the database connect string, currently slacprod.
SQL statements can then be entered at the SQL> prompt. When finished with a session, use commit; to commit your changes to the database, as Oracle does all work inside a transaction by default, and . Punctuation is important in sqlplus. Always end insert, update, delete, select, create, and alter statements with a semicolon. By default, Oracle does all work in a transaction, so you must execute the commit; command to save any changes you've made to the database or the rollback; command to revert them after you have completed a set of changes. When finished use exit; to leave SQLPlus.