QuickSQL
— write shorthand on the left, Oracle DDL appears on the right in real time
Examples ▾
⚙ Settings
? Help
radicle.it
Settings
Primary Key
PK type
— default (guid) —
identityDataType
guid
seq (sequence)
none
Auto PK
— default (yes) —
yes
no
Prefix PK with table name
— default (no) —
yes
no
Naming
Object prefix
Schema
SQL dialect
Data Types
DB version
Char semantics
— default (CHAR) —
CHAR
BYTE
Date data type
— default (DATE) —
DATE
TIMESTAMP
TIMESTAMP WITH TIME ZONE
TIMESTAMP WITH LOCAL TIME ZONE
Boolean data type
— not set —
native (23c boolean)
yn (char Y/N)
Data language
— default (EN) —
EN (English)
JP (Japanese)
KO (Korean)
Auto Columns
Audit columns
— default (no) —
yes
no
Row version
— default (no) —
yes
no
Row key (alphanumeric)
— default (no) —
yes
no
AI enrichment
— default (no) —
yes
no
Output
Include DROP statements
— default (no) —
yes
no
Generate INSERTs
— default (yes) —
yes
no
Duality views
— default (no) —
yes
no
Editionable
— default (no) —
yes
no
Table API (TAPI)
— default (no) —
yes
no
APEX
— default (no) —
yes
no
Table compression
— default (no) —
yes
no
departments /insert 2 name /nn location country employees /insert 4 name /nn vc50 email /lower cost center num date hired job vc255 emp_v = departments employees # settings = { "prefix": null, "semantics": "CHAR", "DV": false, pk: identityDataType }
DDL Oracle SQL
ER Diagram
Copy DDL
Download .sql
Share link
⊡ Fit
+ Zoom
− Zoom
↺ Reset layout