1 SELECT tabCols.COLUMN_NAME AS "Field", 2        tabCols.DATA_TYPE || ‘(‘ || tabCols.DATA_LENGTH || ‘)‘ AS "Type", 3        cons.constraint_type as "Key", 4        tabCols.NULLABLE AS "Null", 5        colcomments.comments AS "Comment" 6   FROM USER_TAB_COLS tabCols 7  inner JOIN user_col_comments colcomments 8     ON colcomments.TABLE_NAME = tabCols.TABLE_NAME 9    AND colcomments.COLUMN_NAME = tabCols.COLUMN_NAME10   left JOIN user_cons_columns conscols11     on conscols.TABLE_NAME = tabCols.TABLE_NAME12    AND conscols.COLUMN_NAME = tabCols.COLUMN_NAME13   left join user_constraints cons14     ON cons.constraint_name = conscols.constraint_name15  where tabCols.TABLE_NAME = ‘TBTEST‘