摘要：select a.constraint_name, a.table_name, b.constraint_name from user_constraints a, user_constraints b where a.constraint_type = 'R' and b.constraint_type = 'P' and a.r_constraint_name = b.constraint_name and b.table_name='FG_ROOM'P 代表主键R 代表外键 阅读全文

摘要：SELECT wmsys.wm_concat(TO_CHAR(SS_NAME)) as SS_NAME , wmsys.wm_concat(TO_CHAR(SS_CHNAME)) as SS_NAME from XX_SYSTEM_SET 阅读全文