How to 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

Use the DESCRIBE table.

Answer 2

In Oracle, you can query dictionary views to get information about schema objects, for example:

SELECT * FROM all_tab_columns WHERE table_name = 'MY_TABLE';

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

DESC my_table