一、oracle 读取表结构和注释
select A.column_name 字段名,A.data_type 数据类型,A.data_length 长度,A.data_precision
整数位, A.Data_Scale 小数位,A.nullable 允许空值,A.Data_default 缺省值,B.comments
备注 from user_tab_columns A,user_col_comments B where a.COLUMN_NAME=b.column_name and A.Table_Name = B.Table_Name and A.Table_Name='TEST'
二、创建数据库连接
create database link linklyoa
connect to lyoa identified by lyoa
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = p570_a.ly.org)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = p570_b.ly.org)(PORT = 1521))
)
(load_blance = yes)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(failover_mode =
(type = select)
(method = basic)
)
)
)';
三、查询表注释
select * from dba_tab_comments where table_type ='VIEW' AND OWNER='CBG' AND COMMENTS IS NOT NULL