Create database in oracle

    show databases sqlplus
    show tables sqlplus
    show users sqlplus
    show pluggable databases sqlplus
  • Show databases sqlplus

    • Oracle show tables

  • Show databases in oracle command-line
  • Use database in oracle
  • Show databases in oracle sql developer
  • Psql show databases

    • Use database in oracle...

    SQL Plus - Show (System Variable) Command

    About

    The SHOW command shows the value of:

    SHOW SGA requires a DBA privileged login.

    Articles Related

    Syntax

    where option represents one of the following:

    • system variable: Represents any system variable set by the SET command.

    • ALL

    • BTI[TLE]: Shows the current BTITLE definition.

    • CON_ID: Displays the id of the Container to which you are connected when connected to a Consolidated Database.

      If issued when connected to a non-Consolidated Database, this command returns 0.

    • CON_NAME: Displays the name of the Container to which you are connected when connected to a Consolidated Database.

    • EDITION: Shows the edition attribute of the existing database.

    • ERR[ORS] [{FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | VIEW | TYPE | TYPE BODY | DIMENSION | JAVA CLASS} [schema.]name]

    • LNO: Shows the current line number (the position in the current page of the display and/or spooled output).

    • PARAMETERS [parameter_name]

    • PDBS: Display the names, ids, mode and restriction status of Pluggable Databases in the

        show database name sqlplus
        sqlplus command to show databases