JDBC Tutorials - Herong's Tutorial Examples - Version 2.21, by Dr. Herong Yang

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

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>

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 Downloading and Installing JDK - Java SE

 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 Database 10g Express Edition (XE) Installation

 Accessing Oracle Server through Web Interface

 Creating Oracle Database Users

SQL*Plus - Oracle Command Line Interface

 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 2005 Express Edition

 Microsoft JDBC Driver for SQL Server - sqljdbc.jar

 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

 Additional Tutorial Notes to Be Added

 References

 PDF Printing Version

SQL*Plus - Oracle Command Line Interface - Updated in 2014, by Dr. Herong Yang