JDBC for Oracle - Herong's Tutorial Examples - v3.13, by Herong Yang
SQL*Plus - Oracle Command Line Interface
This section describes how to use Oracle command line interface, SQL*Plus.
Oracle XE server offers a command line interface called SQL*Plus. The program file of SQL*Plus is located at \local\orablexe\app\oracle\product\21c\bin\sqlplus.exe. "\local\orablexe\app\oracle\product\21c\bin" should be added to the %path% variable already by the Oracle XE installation process. If not, you can add it manually to avoid typing the full path to invoke the "sqlplus" command.
Here is what I did in a command window with "sqlplus", to obtain a list of all users and checking privileges of user "Herong":
herong> sqlplus /nolog SQL*Plus: Release 21.0.0.0.0 - Production ... Version 21.3.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. SQL> connect SYS/HerongY@ng AS SYSDBA ERROR: ORA-12154: TNS:could not resolve the connect identifier specified SQL> connect SYS/anything AS SYSDBA Connected. SQL> SELECT USERNAME FROM ALL_USERS; USERNAME ------------------------- SYS AUDSYS SYSTEM SYSBACKUP SYSDG SYSKM SYSRAC OUTLN GSMADMIN_INTERNAL GSMUSER GSMROOTUSER USERNAME ------------------------- DIP XS$NULL REMOTE_SCHEDULER_AGENT DBSFWUSER ... 37 rows selected.
This tutorial shows a number of interesting behaviors of Oracle server:
Table of Contents
JDBC (Java Database Connectivity) Introduction
►Oracle Express Edition Installation on Windows
Oracle Database Express Edition (XE) Installation
Accessing Oracle Server through Web Interface
Creating Oracle Database Users
►SQL*Plus - Oracle Command Line Interface
SQL*Plus - Create New User and Login
Oracle - Reference Implementation of JdbcRowSet
Oracle - JBDC CallableStatement
Oracle CLOB (Character Large Object) - TEXT
Oracle BLOB (Binary Large Object) - BLOB