Displays information about the database and database elements.
1 – ALL
(B)0[m[4mSHOW[m [4mALL[m qqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqqq>
tqqq> [4mIN[m qwq> db-handle qqqqwqqu
x mqqqqqq , <qqqqqqqj x
mqqq> [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.
3 – CONSTRAINTS
(B)0[m[4mSHOW[m [4mCONSTRAINTS[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqk
lqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqwqk
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 , <qqqqj x x
mqq> [4mFOR[m qqqqqqqwqqwq> relation-name qqwqwqqqqqqqqqqqqqqj x
x mq> view-name qqqqqqj x x
mqqqqqqqqqqqqq , qqqq<qqqj x
x
lqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
x
mqqwqqqqqqqqqqqqqqq>qqqqqqqqqqqwqqqqqqqqqqqqq>
tqq> [4mIN[m qwq> db-handle qqwqqu
x mqqqqqq , <qqqqqj x
mqq> [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.
4 – DATABASES
(B)0[m[4mSHOW[m [4mDATABASES[m qqqwqqqqqqqqqqqqqqqqqqqwqqq>
tqq> [4mALL[m qqqqqqqqqqqu
mqqwqq> db-name qqwqj
mqqqqqqq , <qqqj
Shows the currently invoked database file names, with their
associated database handles. SHOW DATABASES ALL displays the
path name of all databases defined at the current directory in
the data dictionary. You do not have to invoke a database before
you use the SHOW DATABASES ALL statement.
You must have the Oracle Rdb READ privilege for a database to
display information about the database with the SHOW DATABASE
statement.
5 – DATE_FORMAT
(B)0[m[4mSHOW[m [4mDATE_FORMAT[m qqq>
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.
6 – 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.
7 – FIELDS
(B)0[m[4mSHOW[m [4mFIELDS[m qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqk
lqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
mqqqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqwqk
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 , <qqqqj x x
mqqwqqqqqqqqqqqqqwq> [4mFOR[m qqqwqqwq> relation-name qqwqwq>qj x
mwq> name qqqwj x mq> view-name qqqqqqj x x
mqqqq , <qqqj mqqqqqqqqqqqqq , qqqq<qqqj x
x
lqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqj
x
mqqwqqqqqqqqqqqqqqq>qqqqqqqqqqqwqqqqqqqqqqqqq>
tqq> [4mIN[m qwq> db-handle qqwqqu
x mqqqqqq , <qqqqqj x
mqq> [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.
8 – INDEXES
(B)0[m[4mSHOW[m [4mINDEXES[m qqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqk
lqqqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqj
mqqqqwqqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqwqk
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 , <qqqqj x x
mqq> [4mFOR[m qqqwqqqq> relation-name qqqqqwqqj x
mqqqqqqqqqqqqq , qqqq<qqqqj x
lqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqq<qqqqqj
mqqqwqqqqqqqqqqqqqqq>qqqqqqqqqqqwqqqqqqqqqqqqq>
tqq> [4mIN[m qwq> db-handle qqwqqu
x mqqqqqq , <qqqqqj x
mqq> [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.
9 – 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.
10 – PRIVILEGES
(B)0[m[4mSHOW[m [4mPRIVILEGES[m FOR qqqqk
lqqq<qqqqqqqqqqqqqqqj
mqqqqwqqq> [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.
10.1 – 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.
11 – PROTECTION
(B)0[m[4mSHOW[m [4mPROTECTION[m FOR qqqqk
lqqqqqqqqqqqq<qqqqqqqqqqqj
mqwqqq> [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.
12 – 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.
13 – 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 , <qqqqjx
tq> [4mUSER[m qqqqu mq> [4mIN[m [4mALL[m [4mDATABASES[m qqqqqj
mqwq> name qwj
mqqqq , <qj
Lists the names of the relations and the relation-specific
constraints.
You must have the Oracle Rdb READ privilege for the database to use
the SHOW RELATIONS statement.
14 – STORAGE_AREA
(B)0[m[4mSHOW[m [4mSTORAGE[m [4mAREAS[m qqqqqqqqqqqqqqqqk
lqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqj
mqwqqqqqqqqqqqqqq>qqqqqqqqqqqqqqwqqk
tqqqq> [4mALL[m qqqqqqqq>qqqqqqqqqqu x
mqqwq> storage-area-name qqwqqj x
mqqqqqq<qqqqq , <qqqqqqqj x
lqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqj
mqwqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqwqqq>
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.
15 – STORAGE_MAP
(B)0[m[4mSHOW[m [4mSTORAGE[m [4mMAPS[m qqqqqqqqqqqqqqqqqqk
lqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqj
mqwqqqqqqqqqqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqqwqk
tqq> [4mALL[m qqqqqqqqqqqqqqqq>qqqqqqqqqqqqqqqqqqqqqu x
tqqwqq> name qqqqwqqqqqqq>qqqqqqqqqqqqqqqqqqqqqu x
x mqqqqq , <qqqqj x x
mqqwqqqqqq>qqqqwq> [4mFOR[m qqwq> relation-name qwqqj x
mwq> name qwj mqqqqqqqqqq , qqqqqj x
mqqqq , <qj x
lqqqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqqqqqqqqj
mqqwqqqqqqqqqqqqqqq>qqqqqqqqqqqwqqqqqqqqqqqqq>
tqq> [4mIN[m qwq> db-handle qqwqqu
x mqqqqqq , <qqqqqj x
mqq> [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.
16 – STREAMS
(B)0[m[4mSHOW[m [4mSTREAMS[m qqqwqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqwqq>
tqq> [4mIN[m qqwqq> db-handle qqqwqqu
x mqqqqqqq , <qqqqqqj x
mqq> [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.
17 – 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
18 – TRANSFER
[Replication Option]
To get HELP on the SHOW TRANSFER statement, see the entry for
SHOW_TRANSFER under the main topic Replication_Option.
19 – 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 , <qqqqqqqqqj x x
mq> [4mFOR[m qwq> relation-name qwj x
mqqqqqqqqq , <qqqqqj x
lqqqqqqqqqqqqqqqqqqqqq<qqqqqqqqqqqqqqqqj
mqwqqqq>qqqqqqqqqqqqqqqqqqqqqwqqqqqqqqqqqqq>
mq> [4mIN[m qwq [4mALL[m [4mDATABASES[m qwj
mwq db-handle qqwqj
mqqqqq , <qqqqqj
Displays trigger names and definitions of the specified triggers
for a specified database or all invoked databases.
To display information about a trigger for a relation using the
SHOW TRIGGER command, you must have the Oracle Rdb READ privilege
for the database.
20 – VERSIONS
(B)0[m[4mSHOW[m [4mVERSIONS[m qqq>
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.