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) 程序初始化
文章來源于領測軟件測試網 http://www.kjueaiud.com/