Cacher is the code snippet organizer for pro developers

SELECT C.TABLE_NAME , 
     , COL.COLUMN_NAME, 
     , C.CONSTRAINT_TYPE, 
     , COL2.DATA_TYPE, 
     , COL2.DATA_LENGTH 
  FROM USER_CONSTRAINTS C
     , USER_CONS_COLUMNS COL
     , USER_TAB_COLUMNS COL2 
 WHERE C.TABLE_NAME = COL.TABLE_NAME 
   AND C.CONSTRAINT_NAME = COL.CONSTRAINT_NAME 
   AND C.TABLE_NAME = COL2.TABLE_NAME 
   AND COL.COLUMN_NAME = COL2.COLUMN_NAME 
   AND C.CONSTRAINT_TYPE = 'P' 
   AND UPPER(C.TABLE_NAME) = UPPER('TABLE_NAME') 
 ORDER BY C.TABLE_NAME, COL.POSITION