Expanding upon what Lowell and PaulB have said, I recently needed to get the same information myself.

I wrote this query:

select

table_name,

column_name,

decode(data_type,

...