The DESCRIBE_COLUMNS stored procedure describes all attributes of a cursor, such as the field name and type.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_SQL.DESCRIBE_COLUMNS (
c IN INTEGER,
col_cnt OUT INTEGER,
desc_t OUT DESC_TAB);
DBMS_SQL.DESCRIBE_COLUMNS (
c IN INTEGER,
col_cnt OUT INTEGER,
desc_t OUT DESC_TAB2);
DBMS_SQL.DESCRIBE_COLUMNS (
c IN INTEGER,
col_cnt OUT INTEGER,
desc_t OUT DESC_TAB3);
Parameters
| Parameter | Description |
|---|---|
| c | The ID of the cursor. |
| col_cnt | The number of columns selected in the query. |
| desc_t | The description of each column of the table. |