How do I show fields in a table in oracle?

Question

In mysql I can write

show fields from <table>;

What is the closest equivalent in Oracle SQL?

Answer 1

In Oracle you can query the dictionary views to get info on the schema objects, for instance:

SELECT * FROM all_tab_columns WHERE table_name = 'MY_TABLE';

alternatively in SQL*Plus you could use the DESCRIBE command:

DESC my_table

Answer 2

Use DESCRIBE table.