Table of Contents
This chapter briefly introduces the DBMS_TYPES package, and how to use the procedures of the package.
DBMS_TYPES enumerates the data type numbers of Tibero.
The actual type can be found by mapping the column type number obtained using the DBMS_SQL.DESCRIBE_COLUMNS procedure with the value defined in this package.
The following constants are defined in the DBMS_TYPES.
| Algorithm | Description |
|---|---|
| TYPECODE_NUMBER | A NUMBER type |
| TYPECODE_CHAR | A CHAR type |
| TYPECODE_VARCHAR | A VARCHAR type |
| TYPECODE_RAW | A RAW type |
| TYPECODE_DATE | A DATE type |
| TYPECODE_TIME | A TIME type |
| TYPECODE_TIMESTAMP | A TIMESTAMP type |
| TYPECODE_ITV_YTM | An INTERVAL YEAR TO MONTH type |
| TYPECODE_ITV_DTS | An INTERVAL DAY TO SECOND type |
| TYPECODE_LONG | A LONG type |
| TYPECODE_LONG_RAW | A LONG RAW type |
| TYPECODE_BLOB | A BLOB type |
| TYPECODE_CLOB | A CLOB type |
| TYPECODE_BFILE | A BFILE type |
| TYPECODE_ROWID | A ROWID type |
| TYPECODE_CSR | A CSR type |
| TYPECODE_NCHAR | An NCHAR type |
| TYPECODE_NVARCHAR | An NVARCHAR type |
| TYPECODE_NCLOB | An NCLOB type |
| TYPECODE_NONE | An unspecified type, such as NULL. |
| TYPECODE_UNKNOWN | An unknown type |