9.66 V$SQL_TESTCASES
V$SQL_TESTCASES
displays information about test cases exported by SQL Test Case Builder.
You can use this view in conjunction with the V$DIAG_INCIDENT
view. Join the INCIDENT_ID
column in this view with the INCIDENT_ID
column in V$DIAG_INCIDENT
to view information about the test case associated with a particular incident.
The V$SQL_TESTCASES
view requires the existence of a TCB root directory named SQL_TCB_DIR
. This view will not contain any rows if a TCB root directory does not exist, or if the TCB root directory exists with a name other than SQL_TCB_DIR
. The operating system directory to which the TCB root directory refers must be writable by the owner of the Oracle Database binaries.
- In Oracle Autonomous Database environments, the TCB root directory is created automatically on each POD during provisioning.
- For on-premises databases, a user who has been granted the
DBA
role must explicitly create the TCB root directory. See Oracle Database Administrator’s Guide for more information.
Column | Datatype | Description |
---|---|---|
|
|
Test case name |
|
|
SQL identifier of the SQL statement in the test case |
|
|
First 1000 characters of text for the SQL statement in the test case |
|
|
Full text for the SQL statement in the test case, exposed as a CLOB column |
|
|
ID for the incident associated with the test case |
|
|
Type of problem for the incident associated with the test case. Possible values:
These numeric values, and their associated constant values shown in parentheses, correspond to the numeric and constant values for problem type constants in the |
|
|
Creation time for the incident associated with the test case |
|
|
Current status for the incident associated with the test case. Possible values:
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
This view is available starting with Oracle Database release 19c, version 19.1.
See Also: