[oracledb][express] install [11g]

 

(0) Preparation

OracleXE112_Win64

oracle-xe-11.2

(1) Install

qwe123!@#

Destination Folder: C:\oraclexe\

Oracle Home: C:\oraclexe\app\oracle\product\11.2.0\server\

Oracle Base:C:\oraclexe\

Port for 'Oracle Database Listener': 1521

Port for 'Oracle Services for Microsoft Transaction Server': 2030

Port for 'Oracle HTTP Listener': 8080

In the start menu, select Get Started.

Browse: http://127.0.0.1:8080/apex

SYSTEM / qwe123!@#

Run SQL

SQL> connect Administrator as SYSDBA

Enter password:

Connected.

SQL>

Execute SQL 

from a file:

(Assuming the file is located at Z:\SETUP\JDBC_OBE\)

SQL> @Z:\SETUP\JDBC_OBE\testds_oracle.sql

Login as specific user

SQL> CONNECT DBTESTER/welcome1

Connected.

View data created by a specific user

SQL> SELECT * FROM WLS_CLIENT_INFO;

CLIENT_ID

-----------------------------------------

NAME

-----------------------------------------

EMAIL

-----------------------------------------

id2

Homer Sampson

homer.sampson@gmail.com

CLIENT_ID

-----------------------------------------

NAME

-----------------------------------------

EMAIL

-----------------------------------------

id3

Elmer Fuddly

e_fudd@example.com

CLIENT_ID

-----------------------------------------

NAME

-----------------------------------------

EMAIL

-----------------------------------------

id4

Dude McDude

dm@dm.com

.

More Examples:

https://www.oracletutorial.com/