SQLDeveloper Documentation

Master database management with our comprehensive guides, API reference, and step-by-step tutorials. From basic SQL queries to advanced database optimization, everything you need is here.

50+ User Guides
100+ API Methods
30+ Tutorials

Getting Started

Installation & Setup

Learn how to install SQLDeveloper on Windows and configure your first database connection.

Beginner 5 min read

Interface Overview

Familiarize yourself with SQLDeveloper's interface, including navigation, panels, and tools.

Beginner 10 min read

Basic Database Operations

Writing Basic SQL Queries

Master SELECT, INSERT, UPDATE, and DELETE statements with practical examples.

Beginner 15 min read

Data Import & Export

Import data from CSV, Excel, or other sources and export your query results.

Intermediate 20 min read

Advanced Features

Database Administration

Performance Monitoring

Monitor database performance and identify bottlenecks using built-in tools.

Advanced 35 min read

Connection API

POST /api/connections

Create a new database connection

Parameters
Name Type Description Required
host string Database server hostname or IP address Yes
port integer Database server port number Yes
database string Database name Yes
username string Database username Yes
password string Database password Yes
type string Database type (mysql, postgresql, oracle, sqlserver) Yes
Example Request
{
  "host": "localhost",
  "port": 3306,
  "database": "mydb",
  "username": "admin",
  "password": "password123",
  "type": "mysql"
}
Response
{
  "success": true,
  "connectionId": "conn_123456",
  "message": "Connection established successfully"
}

GET /api/connections

List all active connections

Example Response
{
  "connections": [
    {
      "id": "conn_123456",
      "host": "localhost",
      "database": "mydb",
      "type": "mysql",
      "status": "active",
      "connectedAt": "2025-01-18T10:30:00Z"
    }
  ]
}

Query Execution API

POST /api/queries/execute

Execute SQL query on specified connection

Parameters
Name Type Description Required
connectionId string ID of the connection to use Yes
query string SQL query to execute Yes
limit integer Maximum number of rows to return No
timeout integer Query timeout in seconds No
Example Request
{
  "connectionId": "conn_123456",
  "query": "SELECT * FROM users WHERE active = 1 LIMIT 100",
  "limit": 100,
  "timeout": 30
}
Response
{
  "success": true,
  "executionTime": 245,
  "rowCount": 75,
  "columns": ["id", "name", "email", "active"],
  "rows": [
    [1, "John Doe", "[email protected]", true],
    [2, "Jane Smith", "[email protected]", true]
  ]
}

Schema Management API

GET /api/schema/tables

Get list of tables in database

Query Parameters
Name Type Description
connectionId string Connection ID
schema string Schema name (optional)

GET /api/schema/tables/{tableName}/columns

Get column information for a specific table

Example Response
{
  "tableName": "users",
  "columns": [
    {
      "name": "id",
      "type": "int",
      "nullable": false,
      "primaryKey": true,
      "defaultValue": null
    },
    {
      "name": "email",
      "type": "varchar(255)",
      "nullable": false,
      "primaryKey": false,
      "defaultValue": null
    }
  ]
}

Beginner Tutorials

Database Basics: Your First Query

45 min Beginner

Learn the fundamentals of SQL and write your first database queries using SQLDeveloper.

What You'll Learn:
  • Basic SQL syntax and structure
  • How to write SELECT statements
  • Filtering data with WHERE clauses
  • Sorting results with ORDER BY
Prerequisites:
  • SQLDeveloper installed
  • Basic computer skills
Start Tutorial →

Creating and Managing Tables

60 min Beginner

Design and create database tables, define relationships, and manage table structures.

What You'll Learn:
  • Data types and their usage
  • Primary and foreign keys
  • Creating and modifying tables
  • Adding constraints and indexes
Start Tutorial →

Data Manipulation: CRUD Operations

50 min Beginner

Master the fundamental CRUD operations: Create, Read, Update, and Delete data.

What You'll Learn:
  • INSERT statements for adding data
  • UPDATE statements for modifying data
  • DELETE statements for removing data
  • Transaction basics
Start Tutorial →

Intermediate Tutorials

Advanced Query Techniques

90 min Intermediate

Level up your SQL skills with joins, subqueries, and advanced filtering techniques.

What You'll Learn:
  • INNER, LEFT, RIGHT, and FULL OUTER JOINs
  • Subqueries and CTEs (Common Table Expressions)
  • Aggregation functions (SUM, AVG, COUNT, etc.)
  • GROUP BY and HAVING clauses
Prerequisites:
  • Basic SQL knowledge
  • Understanding of table relationships
Start Tutorial →

Database Design Best Practices

120 min Intermediate

Learn the principles of good database design and normalization techniques.

What You'll Learn:
  • Database normalization (1NF, 2NF, 3NF)
  • Entity-relationship modeling
  • Indexing strategies
  • Performance considerations
Start Tutorial →

Data Import and Export Workflows

75 min Intermediate

Master data migration between different formats and database systems.

What You'll Learn:
  • CSV and Excel data import/export
  • Database to database migration
  • Data validation and cleaning
  • Automation of recurring tasks
Start Tutorial →

Advanced Tutorials

Query Optimization and Performance Tuning

150 min Advanced

Deep dive into query performance analysis, execution plans, and optimization techniques.

What You'll Learn:
  • Reading execution plans
  • Index optimization strategies
  • Query rewriting for performance
  • Database server configuration
Prerequisites:
  • Strong SQL knowledge
  • Understanding of database internals
Start Tutorial →

Stored Procedures and Functions

120 min Advanced

Create powerful database-side logic with stored procedures and user-defined functions.

What You'll Learn:
  • Stored procedure syntax and best practices
  • User-defined function creation
  • Error handling and transactions
  • Security considerations
Start Tutorial →

Database Security and Auditing

100 min Advanced

Implement robust security measures and set up comprehensive auditing for your databases.

What You'll Learn:
  • User authentication and authorization
  • Role-based access control
  • Data encryption techniques
  • Audit trail implementation
Start Tutorial →

SQL Syntax Quick Reference

SELECT Statements

-- Basic SELECT
SELECT column1, column2
FROM table_name;

-- SELECT with WHERE
SELECT *
FROM table_name
WHERE condition;

-- SELECT with JOIN
SELECT t1.col1, t2.col2
FROM table1 t1
INNER JOIN table2 t2 ON t1.id = t2.id;

-- SELECT with GROUP BY
SELECT column, COUNT(*)
FROM table_name
GROUP BY column
HAVING COUNT(*) > 1;

INSERT Statements

-- Single row insert
INSERT INTO table_name (col1, col2, col3)
VALUES (value1, value2, value3);

-- Multiple row insert
INSERT INTO table_name (col1, col2)
VALUES (val1, val2), (val3, val4);

-- Insert from SELECT
INSERT INTO table2 (col1, col2)
SELECT col_a, col_b
FROM table1
WHERE condition;

UPDATE Statements

-- Basic UPDATE
UPDATE table_name
SET column1 = value1,
    column2 = value2
WHERE condition;

-- UPDATE with JOIN
UPDATE t1
SET t1.col1 = t2.col2
FROM table1 t1
JOIN table2 t2 ON t1.id = t2.id
WHERE t2.condition = true;

DELETE Statements

-- Basic DELETE
DELETE FROM table_name
WHERE condition;

-- DELETE with JOIN
DELETE t1
FROM table1 t1
JOIN table2 t2 ON t1.id = t2.id
WHERE t2.condition = true;

CREATE TABLE

CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) UNIQUE NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    is_active BOOLEAN DEFAULT TRUE
);

Common Functions

-- Aggregate Functions
SELECT COUNT(*), AVG(price), MAX(price), MIN(price)
FROM products;

-- String Functions
SELECT UPPER(name),
       LOWER(email),
       CONCAT(first_name, ' ', last_name) AS full_name,
       SUBSTRING(description, 1, 100)
FROM users;

-- Date Functions
SELECT CURRENT_DATE,
       CURRENT_TIMESTAMP,
       DATE_FORMAT(created_at, '%Y-%m-%d'),
       DATEDIFF(end_date, start_date) AS days_diff
FROM projects;

Keyboard Shortcuts

Query Editor

Ctrl + Enter Execute query
Ctrl + R Execute selected text
F5 Refresh connection
Ctrl + / Comment/uncomment line
Ctrl + D Duplicate line

Navigation

Ctrl + N New query window
Ctrl + W Close current tab
Ctrl + Tab Switch between tabs
F11 Toggle fullscreen
Ctrl + P Quick search

Results

Ctrl + S Save results
Ctrl + C Copy selected cells
Ctrl + A Select all results
Ctrl + F Find in results

Data Types Reference

Numeric Types

Type Range Description
INT -2^31 to 2^31-1 Standard integer
BIGINT -2^63 to 2^63-1 Large integer
DECIMAL(p,s) Variable Fixed-point number
FLOAT Variable Single-precision floating point
DOUBLE Variable Double-precision floating point

String Types

Type Max Length Description
CHAR(n) n characters Fixed-length string
VARCHAR(n) n characters Variable-length string
TEXT 65,535 bytes Long text
LONGTEXT 4GB Very long text

Date & Time Types

Type Format Description
DATE YYYY-MM-DD Date only
TIME HH:MM:SS Time only
DATETIME YYYY-MM-DD HH:MM:SS Date and time
TIMESTAMP YYYY-MM-DD HH:MM:SS Timestamp with timezone

Database Connection Strings

MySQL

Server=localhost;Database=mydb;Uid=username;Pwd=password;Port=3306;

PostgreSQL

Host=localhost;Port=5432;Username=myuser;Password=mypassword;Database=mydb;

SQL Server

Server=localhost\SQLEXPRESS;Database=mydb;User Id=myuser;Password=mypassword;

Oracle

Data Source=localhost:1521/XE;User Id=myuser;Password=mypassword;

SQLite

Data Source=C:\path\to\database.db;Version=3;

Quick Links

Installation Guide

Step-by-step setup instructions

API Documentation

Complete API reference

Code Examples

Ready-to-use code snippets

Troubleshooting

Common issues and solutions

Ready to Start Building?

Download SQLDeveloper and begin exploring its powerful features today.

Download Now Get Help