Outdated: 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

 Installing and Running Java DB - Derby

 Derby (Java DB) JDBC Driver

 Derby (Java DB) JDBC DataSource Objects

 Java DB (Derby) - DML Statements

 Java DB (Derby) - ResultSet Objects of Queries

 Java DB (Derby) - PreparedStatement

 MySQL Installation on Windows

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

 MySQL CLOB (Character Large Object) - TEXT

 MySQL BLOB (Binary Large Object) - BLOB

 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

 Microsoft SQL Server Express Edition

 Microsoft JDBC Driver for SQL Server

 Microsoft JDBC Driver - Query Statements and Result Sets

 Microsoft JDBC Driver - DatabaseMetaData Object

 Microsoft JDBC Driver - DDL Statements

 Microsoft JDBC Driver - DML Statements

 SQL Server - PreparedStatement

 SQL Server CLOB (Character Large Object) - TEXT

 SQL Server BLOB (Binary Large Object) - BLOB

 JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver

 JDBC-ODBC Bridge Driver - Flat Text Files

 JDBC-ODBC Bridge Driver - MS Access

 JDBC-ODBC Bridge Driver - MS SQL Server

 Summary of JDBC Drivers and Database Servers

 Using Connection Pool with JDBC

Outdated Tutorials

 Outdated: Java SE 8 Installation

 Outdated: Java SE 1.6 Update 2 Installation

 Outdated: JDK 1.6 Documentation Installation

 Outdated: Downloading/Installing Java DB (Derby) 10.2.2

 Outdated: "sysinfo" - Checking Java DB Installation 10.2.2

 Outdated: MySQL Connector/J 5.1 - Download and Installation

 Outdated: MySQL 5.0 Download, Installation and Start

 Outdated: mysqladmin - MySQL 5.0 Admin Tool

 Outdated: MySQL Connector/J 5.0 - Download and Installation

 Outdated: Loading MySQL Connector Java 5.0

 Outdated: Installation of JdbcRowSet Reference Implementation

 Outdated: Oracle Database 10g Express Edition (XE) Installation

 Outdated: Accessing Oracle Server through Web Interface

 Outdated: Creating Oracle Database Users

Outdated: SQL*Plus - Oracle Command Line Interface

 Outdated: JDBC Thin Client-Side Driver Installation

 Outdated: Downloading Microsoft SQL Server 2005 Express Edition

 Outdated: Installing Microsoft SQL Server 2005 Express Edition

 Outdated: Installing AdventureWorksLT Sample Database

 Outdated: Installing Microsoft JDBC Driver 4.2

 Outdated: Installing Microsoft JDBC Driver 1.0

 References

 Full Version in PDF/EPUB