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 - 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 - Production


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


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

Archived Tutorials

 Archived: Downloading and Installing JDK 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


 Full Version in PDF/EPUB