JDBC Tutorials - Herong's Tutorial Examples - v3.12, by Dr. Herong Yang
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>
Table of Contents
JDBC (Java Database Connectivity) Introduction
Installing and Running Java DB - Derby
Derby (Java DB) JDBC DataSource Objects
Java DB (Derby) - DML Statements
Java DB (Derby) - ResultSet Objects of Queries
Java DB (Derby) - PreparedStatement
MySQL JDBC Driver (MySQL Connector/J)
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 - Reference Implementation of JdbcRowSet
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
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: Downloading/Installing Java DB (Derby) 10.2.2
Archived: "sysinfo" - Checking Java DB Installation 10.2.2
Archived: MySQL Connector/J 5.1 - Download and Installation
Archived: MySQL 5.0 Download, Installation and Start
Archived: mysqladmin - MySQL 5.0 Admin Tool
Archived: MySQL Connector/J 5.0 - Download and Installation
Archived: Loading MySQL Connector Java 5.0
Archived: Installation of JdbcRowSet Reference Implementation
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
Archived: Downloading Microsoft SQL Server 2005 Express Edition
Archived: Installing Microsoft SQL Server 2005 Express Edition
Archived: Installing AdventureWorksLT Sample Database
Archived: Installing Microsoft JDBC Driver 4.2