Oracle Database 21c XE + SQL Developer
Installation Guide
This guide provides simple, student-friendly steps to install Oracle Database 21c Express Edition
(XE) along with Oracle SQL Developer on Windows. Follow the steps carefully and use the
screenshots to ensure correct installation.
Step 1: Download Oracle 21c XE
Visit https://www.oracle.com/database/technologies/appdev/xe.html and download 'Oracle
Database 21c Express Edition (XE)' for Windows x64.
Step 2: Download Oracle SQL Developer
Visit https://www.oracle.com/tools/downloads/sqldev-downloads.html and download 'SQL
Developer for Windows 64-bit (with JDK included)'.
Step 3: Install Oracle 21c XE
1. Extract the downloaded OracleXE21_Win64.zip file.
2. Run setup.exe as Administrator.
3. Choose default installation folder.
4. Set password for SYS and SYSTEM users (example: Admin123).
5. Wait for installation to complete.
Step 4: Verify Oracle Installation
Open Command Prompt and type:
sqlplus system/Admin123@localhost/XEPDB1
If login works, installation is successful.
Step 5: Install SQL Developer
1. Extract the downloaded SQL Developer zip.
2. Run sqldeveloper.exe.
3. If asked for JDK path, select the JDK included in the package.
Step 6: Create Connection in SQL Developer
1. Open SQL Developer → Click + New Connection.
2. Enter:
- Connection Name: DBMS_Practicals
- Username: system
- Password: Admin123
- Hostname: localhost
- Port: 1521
- Service Name: XEPDB1
3. Click Test → Status: Success → Save → Connect.
Step 7: First Practice Query
Try the following in SQL Developer:
CREATE TABLE Student(RollNo INT PRIMARY KEY, Name VARCHAR2(50), Dept
VARCHAR2(20));
INSERT INTO Student VALUES (1, 'Raj', 'IT');
COMMIT;
SELECT * FROM Student;
Note: Always remember your SYSTEM password. Use SQL Developer for writing and executing
queries. This setup supports all DBMS practicals including DDL, DML, Joins, Subqueries, PL/SQL,
Triggers, and Cursors.
