Querying Table Attributes 1

[MartinF]

Hi,

Please can anyone tell me if (and how!) i can write an SQL statement to return a specified tables Field Names, DataType and Size? rather than the actual data it contains.

If this is possible, i will be using TOAD to exectue the statement.

many thanks
Martin

 

[Dagon]

select * from all_tab_columns where table_name = 'XXX'
and owner = 'YYY';

 

[MartinF]

Thank you! thats exactly what i wanted.