<p>In mysql I can write</p> <pre class="prettyprint"><code>show fields from <table>; </code></pre> <p>What is the closest equivalent in Oracle SQL?</p>

How do I show fields in a table in oracle?

Tags:

sql

oracle

In mysql I can write

show fields from <table>;

What is the closest equivalent in Oracle SQL?

682

asked Oct 26 '09 16:10

spig

1 Answers

Use DESCRIBE table.

answered Sep 20 '22 18:09

Otávio Décio

Related questions
                            
                                Difference between ON and WHERE clauses in SQL table joins
                            
                                SELECT FOUND_ROWS() return 1 in mysql
                            
                                SQL Get Other Rows From Aggregate Function
                            
                                Is it okay to use string as your ID in a MySQL table?
                            
                                Transpose rows to column and join table
                            
                                Alternative of NOT IN On MySQL
                            
                                Saving delete information to temp tables using into
                            
                                MySQL Query Order By Value in JSON Column
                            
                                SQL NOT IN statement Data is not retrieved Using Index
                            
                                insert maximum selected value as new record oracle
                            
                                sequence doesn't exist ORA-02289
                            
                                Postgres INTERVAL using value from table
                            
                                How to solve # 7 in SQLZOO select names section
                            
                                How to drop a database when it's currently in use?
                            
                                MySQL rows checksum
                            
                                What are the NVL and the NVL2 functions in Oracle? How do they differ?
                            
                                postgresql nextval throws error relation does not exist
                            
                                What does it mean by "Non-deterministic User-Defined functions can be used in a deterministic manner"?
                            
                                How do I return a value to a sqldatareader if value is null?
                            
                                Have PL/SQL Outputs in Real Time

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With