Cheat sheets
Oracle + APEX quick reference
The connection details, URLs and commands you reach for every day.
Local stack connection
- DB host / port
- localhost / 1521
- Service (PDB)
- FREEPDB1
- Admin user
- SYSTEM
- APEX URL
- http://localhost:8080/ords/apex
- EM Express
- https://localhost:5500/em
Docker lifecycle
- Start
- docker compose start
- Stop (keep data)
- docker compose stop
- Remove
- docker compose down
- Full reset
- docker compose down -v
- Status
- docker ps
APEXLang / SQLcl
- Export app
- apex export -applicationid 100 -split -dir ./app100
- Import app
- apex import -dir ./app100 -applicationid 100
- Connect
- sql user/pwd@//host:1521/FREEPDB1
Quick SQL / PL-SQL
- Top-N
- FETCH FIRST 5 ROWS ONLY
- Upsert
- MERGE INTO t USING s ON (…) WHEN MATCHED THEN UPDATE … WHEN NOT MATCHED THEN INSERT …
- Identity
- id NUMBER GENERATED ALWAYS AS IDENTITY
- Bulk
- FORALL i IN ind.FIRST..ind.LAST INSERT …
Oracle DB AI snippets
- Use profile
- EXEC DBMS_CLOUD_AI.set_profile('HR_AI')
- Ask
- SELECT AI how many orders this month
- Review SQL
- SELECT AI showsql …
- Vector top-5
- ORDER BY VECTOR_DISTANCE(embedding, :q, COSINE) FETCH FIRST 5 ROWS ONLY
APEX AI quick refs
- Enable
- Workspace Utilities → Generative AI
- Gen app
- Create → Create App using Generative AI
- Assistant
- Page Designer → AI Assistant panel