Oracle Show

oracle

What is the equivalent of 'show tables'?

SELECT * FROM dba_tables ORDER BY owner, table_name
SELECT * FROM all_tables ORDER BY owner, table_name;

What is the equivalent of 'desc tableName'?

SELECT column_name FROM user_tab_cols WHERE table_name = 'myTableName' ORDER BY COLUMN_ID;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License