As we know Oracle has show command in SQL*Plus, but it only has few functions.
eg:
Oracle DB SHOW Command in 12.2：
SQL> help show
SHOW
----
Shows the value of a SQL*Plus system variable, or the current
SQL*Plus environment. SHOW SGA requires a DBA privileged login.
SHO[W] option
where option represents one of the following terms or clauses:
system_variable
ALL
BTI[TLE]
CON_ID
CON_NAME
EDITION
ERR[ORS] [{ANALYTIC VIEW | ATTRIBUTE DIMENSION | HIERARCHY | FUNCTION
| PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | VIEW | TYPE
| TYPE BODY | DIMENSION | JAVA CLASS} [schema.]name]
LNO
PARAMETERS [parameter_name]
PDBS
PNO
RECYC[LEBIN] [original_name]
REL[EASE]
REPF[OOTER]
REPH[EADER]
SGA
SPOO[L]
SPPARAMETERS [parameter_name]
SQLCODE
TTI[TLE]
USER
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqpug/SHOW.html#GUID-6BB1499D-E537-43D1-A209-401F5DB95E16
>12.42 SHOW
As my experience, if there are more options of SHOW Command in Oracle DB,
such as confirm table DDLs ,tablespace usage/available percent etc.
I think it will be very convenient to DBAs.
Just as reference ,we can see more options of MySQL SHOW Command.
MySQL SHOW Command：
https://dev.mysql.com/doc/refman/8.0/en/show.html
>13.7.6 SHOW Syntax