Archived: SQL*Plus - Oracle Command Line Interface

This section describes how to use Oracle command line interface, SQL*Plus.

Oracle 10g XE server not only offers a Web interface, but it also offers a command line interface called SQL*Plus. The program file of SQL*Plus is located at \local\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus.exe. But you can run it as a command "sqlplus" in a command window.

Here is what I did in a command window with "sqlplus", getting a list of all users and checking privileges of user "Herong":

herong> sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Sep 8 14:08:52 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: Herong/TopSecret

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> SELECT * FROM ALL_USERS;

USERNAME                          USER_ID CREATED
------------------------------ ---------- ---------
HERONG                                 36 01-JUL-07
FLOWS_020100                           35 07-FEB-06
FLOWS_FILES                            34 07-FEB-06
HR                                     33 07-FEB-06
MDSYS                                  32 07-FEB-06
ANONYMOUS                              28 07-FEB-06
XDB                                    27 07-FEB-06
CTXSYS                                 25 07-FEB-06
DBSNMP                                 23 07-FEB-06
TSMSYS                                 20 07-FEB-06
DIP                                    18 07-FEB-06
OUTLN                                  11 07-FEB-06
SYSTEM                                  5 07-FEB-06
SYS                                     0 07-FEB-06

SQL> SELECT username, privilege FROM USER_SYS_PRIVS;

USERNAME                       PRIVILEGE
------------------------------ ----------------------
HERONG                         CREATE TABLE
HERONG                         UNLIMITED TABLESPACE

SQL>

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Oracle Express Edition Installation on Windows

 Oracle JDBC Drivers

 Oracle - Reference Implementation of JdbcRowSet

 Oracle - PreparedStatement

 Oracle - JBDC CallableStatement

 Oracle CLOB (Character Large Object) - TEXT

 Oracle BLOB (Binary Large Object) - BLOB

 Using Connection Pool with JDBC

Archived Tutorials

 Archived: Downloading and Installing JDK 13 on Mac

 Archived: Downloading and Installing JDK 12 on Windows

 Archived: Java SE 8 Installation

 Archived: Java SE 1.6 Update 2 Installation

 Archived: JDK 1.6 Documentation Installation

 Archived: Oracle Database Express Edition (XE) Installation

 Archived: Accessing Oracle Server through Web Interface

 Archived: Creating Oracle Database Users

Archived: SQL*Plus - Oracle Command Line Interface

 Archived: JDBC Thin Client-Side Driver Installation

 References

 Full Version in PDF/EPUB