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']
  | FILES IN LOCATION @location_name['/path'] [PATTERN = 'regex_pattern']
  | SENSITIVE RULES [show_sensitive_rule_option]
};

The show_sensitive_rule_option option is used to specify the rule scope and filter by name or column conditions. The expanded syntax is as follows (the FROM and IN keywords have the same semantics and can be used interchangeably):

show_sensitive_rule_option:
    [ [ FROM | IN ] { table_name | schema_name.table_name | USER user_name }
      [ [ FROM | IN ] schema_name ] ]
  [ LIKE 'pattern' ]
  [ WHERE condition ]

• If no options are specified, all sensitive data protection rules in the current tenant are displayed.
• table_name / schema_name.table_name: Displays rules associated with the specified table. If the table name is the same as a table in the current default schema, you can use FROM table_name FROM schema_name or IN table_name IN schema_name to specify the schema (consistent with the kernel SQLQA use case).
• USER user_name: Displays rules associated with the specified user (corresponding to the "user" semantics in Oracle mode).
• LIKE 'pattern': Filters rules by name pattern.
• WHERE condition: Filters results by column, such as rule_name, ENABLED, PROTECTION_POLICY, etc. (specific columns to reference are determined by the actual result set returned).

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 the SHOW TRACE statement to view the execution information of an SQL statement and output the information 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