Archived: SQL*Plus - Oracle Command Line Interface

JDBC for Oracle - Herong's Tutorial Examples

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