select column_name from dba_cons_columns where onwer='UserName' and table_name='TableName'
楼上的大意了 是owner 不是onwer应该是这样的select * from dba_cons_columns where owner= 'Username' and table_name='TableName' and position = 1而且注意 UserName 和TableName 一定都是大写的
SELECT A.COLUMN_NAME FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B WHERE A.TABLE_NAME = 'TABLE_NAME' AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME AND B.CONSTRAINT_TYPE = 'P';
where onwer='UserName' and table_name='TableName'
where owner= 'Username' and table_name='TableName' and position = 1而且注意 UserName 和TableName 一定都是大写的
FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B
WHERE A.TABLE_NAME = 'TABLE_NAME'
AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
AND B.CONSTRAINT_TYPE = 'P';