How do I show fields in a table in oracle?

In mysql I can 开发者_如何学运维write

show fields from <table>;

What is the closest equivalent in Oracle SQL?

Use DESCRIBE table.

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