Forum Stats

  • 3,874,720 Users
  • 2,266,768 Discussions
  • 7,911,958 Comments

Discussions

Enhancement of SHOW command

Walt Lu-Oracle
Walt Lu-Oracle Member Posts: 22 Employee
edited Oct 1, 2018 12:11AM in Database Ideas - Ideas

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

2 votes

Active · Last Updated