A Query

Following is an interesting query to get the description of all the tables in a database.

SELECT T.TABLE_NAME, ROWNUM "Sr No", T.COLUMN_NAME, T.DATA_TYPE , T.DATA_LENGTH, DECODE (T.NULLABLE, 'N', 'NOT NULL', 'Y', ' ') NULLABLE, T.DATA_DEFAULT, C.COMMENTS FROM ALL_TAB_COLS T, ALL_COL_COMMENTS C WHERE T.OWNER = C.OWNER AND T.TABLE_NAME = C.TABLE_NAME AND T.COLUMN_NAME = C.COLUMN_NAME ORDER BY T.TABLE_NAME