SPOOL OFF

Below is a basic guide on how to create a simple report using SQL Plus, which is a tool that comes with Oracle Database. This guide assumes you have access to Oracle SQL 19c and SQL Plus.

A condensed PDF perfect for beginners who need to get up to speed quickly on SQL and PL/SQL.

In 19c, you can gather statistics on a table as part of an INSERT , UPDATE , DELETE or MERGE without a separate GATHER_STATISTICS job. The parameter is AUTO for real-time.

The primary source for the Oracle Database SQL Language Reference .

: Essential for running scripts and formatting query results in the command-line environment.