Describe Oracle SQL Table

Question

How to describe a table in Oracle SQL, I tried to describe and describe, but it says that desc is not supported. I also tried to show mysql syntax columns from a table, but show also not supported?

Answer 1

You do not say which user interface you are using, but it DESCworks in all of them that I know of. If it is not

SELECT * FROM ALL_TAB_COLUMNS
WHERE TABLE_NAME = 'MY_TABLE'
AND OWNER = 'MY_SCHEMA';

is an alternative to getting the same information.