2) 建立表的关键列视图
CREATE OR REPLACE VIEW v_pkey_column
AS
SELECT b.table_name,b.column_name,b.position
FROM all_constraints a,all_cons_columns b
WHERE a.owner=b.owner AND a.constraint_name=b.constraint_name
AND a.owner=’user1’ AND a.constraint_type=’P’;
3、主要程序代码
1) 程序初始化
文章来源于领测软件测试网 https://www.ltesting.net/