SHOW

Purpose

This statement is used to display information about database objects.

Syntax

SHOW {
  | TABLE STATUS
  | [FULL] PROCESSLIST
  | RECYCLEBIN

  | VARIABLES [LIKE 'pattern']
  | PARAMETERS

  | CHARSET | CHARACTER SET
  | COLLATION

  | CREATE TABLEGROUP tablegroup_name
  | CREATE TABLE table_name
  | CREATE VIEW view_name

  | GRANTS
  | PRIVILEGES

  | ERRORS
  | TRACE [FORMAT='JSON']
};

Parameters

Examples

• View the creation information of the tbl1 table.

    obclient> CREATE TABLE employees (
      emp_id INT PRIMARY KEY,
      emp_name VARCHAR(50) NOT NULL,
      hire_date DATE,
      salary NUMBER(10,2),
      department VARCHAR(30)
    );
    obclient> SHOW CREATE TABLE employees;
  

• View whether the recycle bin is enabled.

  obclient> SHOW VARIABLES LIKE 'recyclebin';
  

• View the contents of the recycle bin.

  obclient> SHOW RECYCLEBIN;
  

• Use SHOW TRACE to view the execution information of a specific SQL statement and output it in JSON format.

  obclient> SET ob_enable_show_trace = 1;
  
  obclient> CREATE TABLE space_travelers (
      astronaut_id INT PRIMARY KEY,
      mission_code VARCHAR(50) NOT NULL,
      launch_date DATE,
      flight_hours NUMBER(10,2),
      space_station VARCHAR(30)
  );
  
  obclient> INSERT INTO space_travelers VALUES(1, 'APOLLO-11', TO_DATE('1969-07-16', 'YYYY-MM-DD'), 195.5, 'MOON');
  
  obclient> INSERT INTO space_travelers VALUES(2, 'ISS-EXP-1', TO_DATE('2000-11-02', 'YYYY-MM-DD'), 4320.8, 'ISS');
  
  obclient> SELECT/*+PARALLEL(2)*/ COUNT(*) FROM space_travelers;
  
  obclient> SHOW TRACE FORMAT='JSON'\G