Oracle SQL

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.

Train a one-class support vector machine on normal data and rank rows by how likely they are to be anomalies.

Compress several attributes into a few features with a feature extraction model, and see which feature describes each row best.

Predict a number with a generalized linear model and get a 95 percent range around each prediction, not just one value.

Tell a classification model that some mistakes cost more than others, and let predictions choose the cheapest outcome.

See how likely every class is for each row, not only the top prediction, and use the probabilities in your decisions.

Build a classification model in the database, score rows in SQL, and explain each prediction with its most important attributes.

Speed up compute-heavy PL/SQL with native compilation, and hide the source of procedures and package bodies by wrapping them.

Find code that compiles but is probably wrong, such as unreachable lines, with PLSQL_WARNINGS, and make the worst ones errors.

Keep debug code and version-specific code in one PL/SQL source, and choose what is compiled with PLSQL_CCFLAGS and DBMS_DB_VERSION.

Build parameterized views and reusable query shapes with functions marked SQL_MACRO(TABLE), which Oracle expands into the calling query.