View
O2_EXTENSION_VERSION_INFO
This view outputs the version information for each O2 extension and O2 and when it was updated.
VERSION_INFO
TEXT
The version information for each O2 extension and O2 and when it was updated.
O2_MEMORY_CONTEXT_INFO
O2_MEMORY_CONTEXT_INFO is a view that provides memory context information used by O2.
NAME
TEXT
The name of the memory context.
IDENT
TEXT
Additional expression identifier information for that context.
PARENT
TEXT
The name of the parent memory context.
LEVEL
INTEGER
The hierarchical level of the memory context.
TOTAL_BYTES
BIGINT
The total amount of memory allocated by the context
TOTAL_NBLOCKS
BIGINT
The number of blocks allocated.
FREE_BYTES
BIGINT
The available space of the currently allocated memory.
FREE_CHUNCKS
BIGINT
The number of available memory fragments.
USED_BYTES
BIGINT
The amount of memory actually in use.
O2_SHARED_MEMORY_INFO
O2_SHARED_MEMORY_INFO is a view that shows SHARED MEMORY usage.
KEY
TEXT
The identifier of the shared memory segment
USAGE
INTEGER
Usage
DUAL
DUAL tables can be used in SELECT statements that do not reference another table, and are useful when you need to return at least one row. Selecting from a DUAL table is useful when you use a SELECT statement to calculate a constant expression. Because there is only one row in a DUAL table, the constant value is returned only once.
DUMMY
TEXT
'X'
DBA_TAB_COLUMNS
DBA_TAB_COLUMNS shows the columns of all tables and views in the database.
TABLE_NAME
TEXT
The names of the tables and views.
COLUMN_NAME
TEXT
The name of the column.
DATA_TYPE
TEXT
The data type of the column.
DATA_LENGTH
INTEGER
The length of the data (bit size of the number type).
DATA_PRECISION
INTEGER
The precision of the NUMERIC type.
DATA_SCALE
INTEGER
The number of decimal places.
NULLABLE
TEXT
Whether NULLs are allowed in the column.
COLUMN_ID
INTEGER
The consecutive numbers in the column.
DBA_TABLES
DBA_TABLES shows all tables in the database.
TABLE_NAME
TEXT
Table name
DBA_CONS_COLUMNS
DBA_CONS_COLUMNS shows all constrained columns in the database.
CONSTRAINT_NAME
TEXT
The name of the constraint.
COLUMN_NAME
TEXT
The name of the column
TABLE_NAME
TEXT
The name of table
DBA_CONSTRAINTS
DBA_CONSTRAINTS shows all constraint definitions for all tables in the database.
CONSTRAINT_NAME
TEXT
The name of the constraint.
INDEX_NAME
TEXT
The name of index
CONSTRAINT_TYPE
TEXT
Constraint type 'P' is Primary key and 'R' is Referential integrity.
TABLE_NAME
TEXT
The name of table
R_CONSTRAINT_NAME
TEXT
Unique for the referenced table
PRODUCT_COMPONENT_VERSION
PRODUCT_COMPONENT_VERSION is a view of the version and status for a component product.
PRODUCT
TEXT
The name of the component
VERSION
TEXT
Version
STATUS
TEXT
Architecture and build mode
DBA_OBJECTS
DBA_OBJECTS is a view of all objects in the database.
OBJECT_NAME
TEXT
오브젝트 이름이다.
SUBJECT_NAME
TEXT
하위 객체 이름이다. 호환성을 위해 추가된 컬럼이다.(Default : NULL)
OBJECT_ID
OID
오브젝트 ID다.
OBJECT_TYPE
TEXT
오브젝트 타입이다.
CREATED
TIMESTAMP
오브젝트 생성일시다. 호환성을 위해 추가된 컬럼이다.(Default : NULL)
LAST_DDL_TIME
TIMESTAMP
DDL로 인한 오브젝으 및 하위 오브젝트의 변경에 대한 시점이다. 호환성을 위해 추가된 컬럼이다.(Default : NULL)
STATUS
TEXT
오브젝트의 상태이다.
NAMESPACE
OID
오브젝트의 NAMESPACE다.
DBA_PROCEDURES
DBA_PROCEDURES shows all available functions and procedures with their associated properties.
OBJECT_NAME
TEST
The name of object
DBA_SOURCE
DBA_SOURCE shows the text source of all stored objects in the database.
LINE
INTEGER
The line number of the source.
OID
OID
The ID of the object.
TEXT
TEXT
The text source of the saved object.
NAME
TEXT
The name of the object.
TYPE
TEXT
The type of the object.
DBA_VIEWS
DBA_VIEWS shows all views in the database.
VIEW_NAME
TEXT
The name of the view
OWNER
NAME
The name of the view generator
DBA_IND_COLUMNS
DBA_IND_COLUMNS shows the columns of all indexes for all tables in the database..
COLUMN_NAME
TEXT
The name of the column
INDEX_NAME
TEXT
The name of the index
TABLE_NAME
TEXT
The name of the table
Last updated