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

Use DESCRIBE table.

Answer 2

Hi spig,

in Oracle you will query the dictionary views to get info on the schema objects:

SELECT * FROM all_tables WHERE table_name = 'MY_TABLE';

alternatively in SQL*Plus you could:

DESC my_table