1 SHOW Displays information about the database and database elements. 2 ALL (B)0[m[4mSHOW[m [4mALL[m qqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqq> tqqq> [4mIN[m qwq> db-handle qqqqwqqu x mqqqqqq , [4mIN[m [4mALL[m [4mDATABASES[m qqqqqqqqj Shows all the current information about the currently invoked databases. You must have the Oracle Rdb READ privilege to the database to use the SHOW ALL statement. 2 COLLATING_SEQUENCE (B)0[m [4mSHOW[m [4mCOLLATING_SEQUENCE[m qqwqqqqqqqqqqqqqqqqqqqwqq> mq> sequence-name qqj Displays the collating sequences for databases and fields. You can specify the name of the collating sequence you wish to display. You must have the Oracle Rdb READ privilege to the database to use the SHOW COLLATING_SEQUENCE statement. 2 CONSTRAINTS (B)0[m[4mSHOW[m [4mCONSTRAINTS[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqk lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk tqq> [4mALL[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x tqq> [4mSYSTEM[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x tqq> [4mUSER[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x tqqwqq> name qqqqwqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x x mqqqqq , [4mFOR[m qqqqqqqwqqwq> relation-name qqwqwqqqqqqqqqqqqqqj x x mq> view-name qqqqqqj x x mqqqqqqqqqqqqq , qqqqqqqqqqqqqqqwqqqqqqqqqqqqq> tqq> [4mIN[m qwq> db-handle qqwqqu x mqqqqqq , [4mIN[m [4mALL[m [4mDATABASES[m qqqqqqj Lists the names and definitions of constraints. You must have the Oracle Rdb READ privilege for the database to use the SHOW CONSTRAINTS statement. 2 DATABASES (B)0[m[4mSHOW[m [4mDATABASES[m qqqwqqqqqqqqqqqqqqqqqqqwqqq> tqq> [4mALL[m qqqqqqqqqqqu mqqwqq> db-name qqwqj mqqqqqqq , Displays the value for the date-number argument of the SET DATE_ FORMAT statement. You can use the SHOW DATE_FORMAT statement without invoking a database, so you do not need any special Oracle Rdb privileges to use the statement. 2 DICTIONARY (B)0[m[4mSHOW[m [4mDICTIONARY[m qqqq> Shows the current default directory in the data dictionary. You can use the SHOW DICTIONARY statement without invoking a database, so you do not need any special Oracle Rdb privileges to use the statement. 2 FIELDS (B)0[m[4mSHOW[m [4mFIELDS[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqk lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk tqq> [4mALL[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x tqq> [4mSYSTEM[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x tqq> [4mUSER[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x tqqwqq> name qqqqwqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x x mqqqqq , [4mFOR[m qqqwqqwq> relation-name qqwqwq>qj x mwq> name qqqwj x mq> view-name qqqqqqj x x mqqqq , qqqqqqqqqqqwqqqqqqqqqqqqq> tqq> [4mIN[m qwq> db-handle qqwqqu x mqqqqqq , [4mIN[m [4mALL[m [4mDATABASES[m qqqqqqj SHOW FIELDS lists the globally defined fields and their attributes. SHOW FIELDS FOR relation-name lists the local names of the fields and their locally defined attributes within the relation. You must have the Oracle Rdb READ privilege for a database to display information about a field with the SHOW FIELDS statement. 2 INDEXES (B)0[m[4mSHOW[m [4mINDEXES[m qqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqk lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk tqq> [4mALL[m qqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x tqq> [4mSYSTEM[m qqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x tqq> [4mUSER[m qqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqu x tqqwqq> name qqqqwqqqqqqqq>qqqqqqqqqqqqqqu x x mqqqqq , [4mFOR[m qqqwqqqq> relation-name qqqqqwqqj x mqqqqqqqqqqqqq , qqqqqqqqqqqqqqqwqqqqqqqqqqqqq> tqq> [4mIN[m qwq> db-handle qqwqqu x mqqqqqq , [4mIN[m [4mALL[m [4mDATABASES[m qqqqqqj Shows the names and definitions of indexes. To use the SHOW INDEXES statement to display information about an index, you must have the Oracle Rdb READ privilege for the database. 2 LANGUAGE (B)0[m[4mSHOW[m [4mLANGUAGE[m qqq> Displays the language that will be used for date and time input and display. You can use the SHOW LANGUAGE statement without invoking a database, so you do not need any special Oracle Rdb privileges to use the statement. 2 PRIVILEGES (B)0[m[4mSHOW[m [4mPRIVILEGES[m FOR qqqqk lqqq [4mDATABASE[m qqqqqqqqqqq>qqqqqqqqqqqqqqqqqwqqq> tqqq> [4mRELATION[m qq> relation-name qqqqqqqqqqqu tqqq> [4mVIEW[m qqqqqq> view-name qqqqqqqqqqqqqqqu mqqq> [4mFIELD[m q> field-name [4mIN[m relation-name qj Displays your access control list (ACL) entry when Oracle Rdb matches your UIC with the identifier specified in the ACL entry (ACE). Although your UIC may match many ACL entries, Oracle Rdb stops when it finds the first match and grants you those access rights. You can display your particular privileges for the database, a relation, or a view. Note the difference between the SHOW PRIVILEGES and SHOW PROTECTION statements. The SHOW PROTECTION statement displays all ACL entries. The SHOW PRIVILEGES statement displays only your ACE or the privileges you have to a database object as a result of holding one or more of the OpenVMS or Oracle Rdb overriding privileges. You must have the Oracle Rdb READ privilege for a database to use the SHOW PRIVILEGES statement. 3 More You must invoke a database before you issue the SHOW PRIVILEGES statement. The display for the SHOW PRIVILEGES statement reflects information stored following a COMMIT or ROLLBACK statement and a detach from the database with a FINISH statement. Unlike the SHOW PROTECTION statement, SHOW PRIVILEGES will not reflect uncommitted changes. Any changes you make to your privileges or those of other users do not take effect until you detach from the database. In order to perform a certain operations, you must have the correct access mode privilege (READ, WRITE, MODIFY, or ERASE) on both the database and the relation. Therefore, the SHOW PRIVILEGES display for a relation will drop any access mode privileges that are not present for the database before displaying the privileges for the relation. If you hold one or more of the OpenVMS override privileges (SYSPRV, OPER, or SECURITY) or one or more of the Oracle Rdb role- oriented privileges (ADMINISTRATOR, OPERATOR, or SECURITY), you are implicitly granted privileges to database objects as a result of an ACL override. You operate as if you actually hold the privileges you are implicitly granted, even though these privileges are not stored in the ACL. The SHOW PRIVILEGES statement displays the privileges you have to a database object as a result of holding the OpenVMS override privilege or Oracle Rdb role-oriented privilege. The SHOW PRIVILEGES statement displays only those privileges that are valid for the database object. For example, although you may hold the Oracle Rdb ADMINISTRATOR, OPERATOR, or SECURITY database privileges, these privileges are not displayed when you issue the SHOW PRIVILEGES statement for a relation because they are not relation privileges. 2 PROTECTION (B)0[m[4mSHOW[m [4mPROTECTION[m FOR qqqqk lqqqqqqqqqqqq [4mDATABASE[m qqqqqqqqqqq>qqqqqqqqqqqqqqqqqwqqq> tqqq> [4mRELATION[m qq> relation-name qqqqqqqqqqqu tqqq> [4mVIEW[m qqqqqq> view-name qqqqqqqqqqqqqqqu mqqq> [4mFIELD[m q> field-name [4mIN[m relation-name qj Displays the access control list for the named database, relation, field or view. To use the SHOW PROTECTION statement to display the protection for a database, relation, view, or field, you must have the Oracle Rdb READ privilege to the database. 2 RADIX_POINT (B)0[m[4mSHOW[m [4mRADIX_POINT[m qq> Displays the character that will be used as the radix point in output displays. The radix point is the symbol that separates units from decimal fractions. For example, in the number 98.6, the period is the radix point. You can use the SHOW RADIX_POINT statement without invoking a database, so you do not need any special Oracle Rdb privileges to use the statement. 2 RELATIONS (B)0[m[4mSHOW[m [4mRELATIONS[m qwqqqqqqqqqqqqwqwqqqqqqqqqqqqqqqqqqqqqqqqqwq> tq> [4mALL[m qqqqqu tq> [4mIN[m qqwq> db-handle qqwu tq> [4mSYSTEM[m qqu x mqqqqqqq , [4mUSER[m qqqqu mq> [4mIN[m [4mALL[m [4mDATABASES[m qqqqqj mqwq> name qwj mqqqq , qqqqqqqqqqqqqqwqqk tqqqq> [4mALL[m qqqqqqqq>qqqqqqqqqqu x mqqwq> storage-area-name qqwqqj x mqqqqqqqqqqqqqqqqwqqq> tqqq> [4mIN[m qqqqqqq> db-handle qqqu mqqq> [4mIN[m [4mALL[m [4mDATABASES[m qqqqqqqqj Displays the names of all storage areas for the currently invoked database, for a specific database, or for all invoked databases. If you specify a storage area name, the statement displays the following information about the storage area: o Page format o Identification of read-only areas o Page size o Storage file specification o Storage file allocation, minimum extent, maximum extent, and percent growth o Snapshot file specification o Snapshot file allocation, minimum extent, maximum extent, and percent growth You must have the Oracle Rdb READ privilege for a database to use the SHOW STORAGE AREAS statement. 2 STORAGE_MAP (B)0[m[4mSHOW[m [4mSTORAGE[m [4mMAPS[m qqqqqqqqqqqqqqqqqqk lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqk tqq> [4mALL[m qqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqqu x tqqwqq> name qqqqwqqqqqqq>qqqqqqqqqqqqqqqqqqqqqu x x mqqqqq , qqqqwq> [4mFOR[m qqwq> relation-name qwqqj x mwq> name qwj mqqqqqqqqqq , qqqqqj x mqqqq , qqqqqqqqqqqwqqqqqqqqqqqqq> tqq> [4mIN[m qwq> db-handle qqwqqu x mqqqqqq , [4mIN[m [4mALL[m [4mDATABASES[m qqqqqqj Displays information about storage maps. You must have the Oracle Rdb READ privilege for the database to display the relation's storage map with the SHOW STORAGE MAPS statement. 2 STREAMS (B)0[m[4mSHOW[m [4mSTREAMS[m qqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq> tqq> [4mIN[m qqwqq> db-handle qqqwqqu x mqqqqqqq , [4mIN[m [4mALL[m [4mDATABASES[m qqqqqqqqqj Identifies the streams that are currently open. You must have the Oracle Rdb READ privilege to the database to use the SHOW STREAMS statement. 2 TRANSACTION (B)0[m[4mSHOW[m [4mTRANSACTION[m qqq> Displays information about the transaction mode, transaction id (TID), transaction sequence number (TSN), and, for read/write transactions, the status of updates and the full recovery-unit journal (RUJ) file specification. The SHOW TRANSACTION statement also shows whether or not fast commit is enabled. You must have the Oracle Rdb READ privilege for a database to use the SHOW TRANSACTION statement. The following START_TRANSACTION statement starts a read/write transaction reserving the EMPLOYEES table for shared read. Note that the SHOW TRANSACTION statement shows that fast commit is enabled for the database. RDO> START_TRANSACTION READ_WRITE RESERVING cont> EMPLOYEES FOR SHARED READ RDO> SHOW TRANSACTION All Transactions in Database with filename MF_PERSONNEL a read-write transaction is in progress - updates have not been performed - fast commit is enabled - transaction sequence number (TSN) is 121 - snapshot space for TSNs less than 121 can be reclaimed - session ID number is 42 2 TRANSFER [Replication Option] To get HELP on the SHOW TRANSFER statement, see the entry for SHOW_TRANSFER under the main topic Replication_Option. 2 TRIGGERS (B)0[m[4mSHOW[m [4mTRIGGERS[m qqq>qqqqqqqqqqqqqqqqqqqqqqqqk lqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj mqqqqqqqwqqqqqqqqqqqqqqq>qqqqqqqqqqqqwqk tqqq> [4mALL[m qqqqqqqqqqqqqqqqqqqu x tqqq> [4mSYSTEM[m qqqqqqqqqqqqqqqu x tqqq> [4mUSER[m qqqqqqqqqqqqqqqqqu x twqq> trigger-name qwqqqqqqqqu x xmqqqqq , [4mFOR[m qwq> relation-name qwj x mqqqqqqqqq , qqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqq> mq> [4mIN[m qwq [4mALL[m [4mDATABASES[m qwj mwq db-handle qqwqj mqqqqq , Displays all versions of the Oracle Rdb components you are running. You can use the SHOW VERSIONS statement without invoking a database, so you do not need any special Oracle Rdb privileges to use the statement.