Buy me a coffee
Oracle SQL / Procedure Builder
SELECT
INSERT
UPDATE
DELETE
Basic Settings
Procedure Name
Main Table
SELECT Columns
Table Alias
Column Name
Aggregate
Column Alias
None
MAX
MIN
COUNT
SUM
AVG
✕
+ Add Column
JOIN
+ Add JOIN
WHERE Conditions
+ Add WHERE
GROUP BY
Use GROUP BY
ORDER BY
Use ORDER BY
Generated SQL
Wrap in Procedure
Copy
SELECT col FROM main_table t ;