Format SHOW VERSION
1 – Description
The SHOW VERSION command displays the following information about one or more respositories that you have invoked and to which the CDO session is currently attached: o Version number of Oracle CDD/Repository that is installed on your system o Major and minor version numbers of each repository o Fully qualified name of each repository o Version numbers of Oracle CDD/Repository with which each repository is compatible If you issue the SHOW VERSION command and you have not invoked a repository during the CDO session, CDO displays only the version of Oracle CDD/Repository that is currently installed. Commands such as DEFINE FIELD or SHOW FIELD will invoke a repository; however, the SET DEFAULT or SHOW DEFAULT commands will not. If you issue a DIRECTORY command and the repository contains elements, the session will invoke a repository.
2 – Examples
1.CDO> SHOW DEFAULT CDO> SHOW VERSION Installed version of Oracle CDD/Repository is V7.0.1 In this example, the SHOW DEFAULT command does not invoke a repository. Therefore, the SHOW VERSION command displays only the version of Oracle CDD/Repository that is currently installed. 2.CDO> SHOW FIELD Definition of field A1 | Datatype text size is 1 characters | Row_major array 1:4 Definition of field A1_KEY | Datatype text size is 1 characters . . . CDO> SHOW VERSION Installed version of Oracle CDD/Repository is V7.0.1 Attached to repository CDD$R0:[SMITH.REPOS3] Repository Version V6.1 / V7.0.1 Internal Major Version 26 Internal Minor Version 3 In this example, the SHOW FIELD command invokes a repository. Consequently, the SHOW VERSION command displays information about the repository to which it is attached.