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":
C:\>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>
