重庆思庄Oracle、Redhat认证学习论坛

标题: 如何确定oracle xmltype类型段对应是哪个字段 [打印本页]

作者: 郑全 时间: 2021-5-17 19:35
标题: 如何确定oracle xmltype类型段对应是哪个字段
SQL> select TABLE_NAME,COLUMN_NAME,SEGMENT_NAME from  dba_lobs where segment_name='SYS_LOB0000087534C00009$$';

TABLE_NAME          COLUMN_NAME       SEGMENT_NAME
-------------------- -------------------- ------------------------------
ANTETYPE_LIST       SYS_NC00009$       SYS_LOB0000087534C00009$$

SQL> select TABLE_NAME,COLUMN_NAME,DATA_TYPE,HIDDEN_COLUMN,COLUMN_ID from dba_tab_cols where table_name='ANTETYPE_LIST';

TABLE_NAME          COLUMN_NAME       DATA_TYPE          HIDDEN  COLUMN_ID
-------------------- -------------------- -------------------- ------ ----------
ANTETYPE_LIST       DOC_KIND          VARCHAR2          NO          18
ANTETYPE_LIST       NEWGROUP          NUMBER             NO          19
ANTETYPE_LIST       DIS_SAMPLE          NUMBER             NO          20
ANTETYPE_LIST       ID                RAW                NO             1
ANTETYPE_LIST       KIND                VARCHAR2          NO             2
ANTETYPE_LIST       CODE                VARCHAR2          NO             3
ANTETYPE_LIST       TITLE             VARCHAR2          NO             4
ANTETYPE_LIST       NOTE                VARCHAR2          NO             5
ANTETYPE_LIST       TYPE                NUMBER             NO             6
ANTETYPE_LIST       GID                RAW                NO             7

ANTETYPE_LIST       CONTENT             XMLTYPE             NO          8
ANTETYPE_LIST       SYS_NC00009$       CLOB                YES          8

ANTETYPE_LIST       PAGE_RESET          NUMBER             NO             9
ANTETYPE_LIST       STYLE_RESET       NUMBER             NO          10
ANTETYPE_LIST       DISABLE             NUMBER             NO          11
ANTETYPE_LIST       OPTIONS             XMLTYPE             NO          12
ANTETYPE_LIST       SYS_NC00014$       CLOB                YES          12
ANTETYPE_LIST       CREATOR             VARCHAR2          NO          13
ANTETYPE_LIST       CREATE_TIME       DATE                NO          14
ANTETYPE_LIST       EDITOR             VARCHAR2          NO          15
ANTETYPE_LIST       EDIT_TIME          DATE                NO          16
ANTETYPE_LIST       CATEGORY          VARCHAR2          NO          17

22 rows selected.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)