Oracle SQL

Fix queries that mix SUM or COUNT with plain columns and no GROUP BY, by grouping, dropping the column, or using OVER ().

Find where Oracle expected a value or column in ORA-00936: trailing commas, empty lists, and comparisons with no right side.

Fix statements Oracle reads as finished too early, and understand the ORA-03048 and ORA-03049 messages 26ai shows instead.

Find what ended the select list too early in ORA-00923: a missing comma, a reserved word as alias, or SELECT TOP.

Tell Oracle which table a shared column name belongs to, with table aliases or a join with USING, and fix ORA-00918.

Find the missing comma in an INSERT column list or VALUES list from the position in the ORA-00917 error.

Find the character behind ORA-00911, often syntax from MySQL or JDBC, and rewrite it the Oracle way.

Use the error position to find where Oracle expected a closing parenthesis, and fix unbalanced lists and subqueries.

Find the name Oracle cannot resolve in ORA-00904 and fix typos, case-sensitive quoted columns, and misplaced aliases.

Find which constraint, column, and value caused ORA-00001, and load data without duplicates using MERGE or NOT EXISTS.

Make every SQLcl and SQL*Plus session start with your settings: output format, NLS formats, time zone, and server output.

Turn a query into a readable report with column headings and formats, grouped rows, and subtotals, without changing the SQL.

Reuse scripts with different values through DEFINE, ampersand references, and variables filled from query results.

Give frequent queries short names in SQLcl, pass arguments to their bind variables, and keep them across sessions.

Turn any query into CSV, JSON, INSERT statements, or delimited text in SQLcl with one SET SQLFORMAT command.

Rank every column of a table by how much it explains a target column, in one call and without building a model.

Score held-out rows, then measure a classification model with a confusion matrix, its accuracy, and the area under the ROC curve.

Let a single query build a temporary model from its own rows and score them, with the analytic form of PREDICTION.