SQL*Plus History In Oracle 12.2

In Oracle 12.2, SQL*Plus can keep the history of the commands executed. You can enable or disable the HISTORY command in the current SQL*Plus session by using the SET HISTORY command. The history feature is not enabled by default, so after you start SQL*Plus, you need to enable history by running “set hist[ory] on”


Read More

VARIABLE In Oracle 12.2

    You may use SQL*Plus to test queries with bind variables. Here is what you do before 12.2:

You can now simply:

Read More