desc 是在select 查询时,按某字段进行降序排序;你要查看某个表的表结构,你可以通过下面的查询语句进行查看某个表的表结构
SELECT T.COLUMN_NAME, T.DATA_TYPE, T.DATA_LENGTH, CASE T.NULLABLE WHEN 'N' THEN '否' WHEN 'Y' THEN '是' END NULLABLE,
C.COMMENTS FROM USER_TAB_COLUMNS T,USER_COL_COMMENTS C
WHERE T.TABLE_NAME = C.TABLE_NAME AND T.COLUMN_NAME = C.COLUMN_NAME AND T.TABLE_NAME = UPPER('你要查的表名称')