Study aids

SQL Behind the Scenes what Oracle does with your query, step by step

Layout

Show

Move (wide screens)

Your SQL

SQL*Plus output


      
Ready

Pick a worked example or type a query

Each step of the query becomes a frame: the tables it reads, the rows it keeps or drops, the groups it forms. The ERD shows which tables and keys each step uses.

Step 0 / 0

key = primary key@ = foreign keydrag boxes to rearrange

Tables

Worked examples

Reading companion

Tick what you've read, or press Watch to see it run.

Character codes

ASCII covers 0–127. The extended DOS table uses CP437; other encodings differ. Thai uses Unicode, including digits ๐–๙. Combining marks appear on a dotted circle so you can see them.

Oracle ASCII() and CHR() depend on the database character set. These Thai values are Unicode code points, not guaranteed Oracle return values. Oracle 19c · Thai codes · CP437 mapping