retreival of column name

[Guest_imported]

Hai

i want to retrieve the column name and data type of the column for the table.

please guide me how to write Query fot the same

regards

Dhinakaran

 

[jee]

SELECT column_name, data_type
FROM sys.all_tab_columns
WHERE TABLE_NAME = Whatever;

This must be done by a user who has SELECT access on the sys.all_tab_columns view.

 

[alexhu]

desc <table_name>

Alex