Oracle-compatible mode — runs in your browser

Oracle Database Playground

Write Oracle SQL and run it instantly — no server, no signup. Practice DUAL, NVL, SYSDATE, ROWNUM, LISTAGG and more, with the common Oracle-only syntax bridged automatically.

Oracle-Compatible Mode 3 Difficulty Levels 20 Hands-On Exercises Timed Challenge Mode
Difficulty:
Exercise 1 of 8 0 solved
Timed Challenge
Question
easy

List Every Department

Retrieve every department, ordered by dept_name.

Expected Columns:
Database Info

Database Schema

Table structures and relationships

dual (1/5)
Oracle Notes
    SQL Editor
    Ctrl+Enter to run Ctrl+/ to comment Loading Oracle-compatible engine… 0 chars
    Results

    Run a query to see results

    Comments