FROM QUESTION TO REPORT
Your SQL.
A clear path to insight.
A technical look at how your Fusion reporting request travels.
query.sql
SELECT :P_VALUE AS VALUE_TO_SHOW
FROM dual01SQL workspaceWrite SQL · enter parameters
02Application backendAuthorize · encode · HTTPS
03BI Publisher reportReceive the report request
04QueryRunner data modelDecode SQL · open a cursor
05Structured report outputRead the cursor · return XML
06Results & exportsExplore rows · CSV · Excel
SELECT organization_id, COUNT(*) item_count
FROM egp_system_items_b
GROUP BY organization_id;
ORGANIZATION_IDITEM_COUNT
204120
30590
30660
Items by organizationIllustrative data · no connection
SQL HopYOUR SQL HOP ACCOUNTSign in to your account.
Manage account security and billing here. Use SQL Hop Desktop for Oracle queries.
Forgot password? · Service status
New organization? Create an account.
Joining a team? Contact your organization administrator.
Oracle authentication is separate. No Oracle credentials are collected here.