SQL Plus vs SQL Developer

SQL Plus

Log in to Oracle Database with SQL Plus

1. Launch the Program

Type SQL Plus in the Windows search box and open the application

2. Explanation of Login Parameters

Enter the command

Username: sys as sysdba
Password: [Administrator password set during database installation]Code language: JavaScript (javascript)

Notes

1. sys account: Oraclesuper‑administrator with highest privileges. You must log in with the identity as sysdba;
2. system account: Regular administrator account. No need to append as sysdba when logging in;
3. Login success indicator: The SQL> prompt appears;
   Oracle Database 12c Enterprise Edition Release 12.2.0.1.0

3. Test Connectivity

Enter commands right after the SQL> prompt

1. Check database version

select * from v$version;Code language: JavaScript (javascript)

2. Unlock scott test user

alter user scott account unlock;
alter user scott identified by Qweqwe123;

After execution, log in again with username scott and password Qweqwe123

select * from emp;Code language: JavaScript (javascript)

SQL Developer

Official Download Link
https://www.oracle.com/database/sqldeveloper/technologies/download/

Download

Two Windows packages are available on the page:

1. Windows 64‑bit with JDK 17 included (Highly Recommended)
   Bundled with JDK, just extract and run, no extra Java installation required. Best choice for beginners.
   File name: sqldeveloper‑26.2.0.186.2220‑x64.zip
2. Windows 64‑bit (No JDK included)
   Java is not included. You need to manually specify local JDK path on startup, for users who already have Java installed.

Accept License Agreement

1. Open the link above
2. Scroll down the page and check License Agreement
3. Click your corresponding system version to start downloading

You now need a free Oracle account to download (register with email, completely free, no payment required)

How to Use (Portable, no installation)

1. Extract archive to apure English path(avoid folders with Chinese characters or spaces, e.g. D:\Tools\sqldeveloper)
2. Open the folder and launch sqldeveloper.exe

SQL Developer is Oracle’s database management tool, similar to SQL Server Management Studio. It is a graphical Oracle database management utility. It can connect to multiple Oracle databases and perform graphical database operations such as table creation and deletion. It also supports running SQL statements and querying tables.

SQL Plus vs SQL Developer