Get all column names from database table in orders in SQL Server using Toad Oracle

Hi freelanzor,

The Oracle equivalent for information_schema.COLUMNS is USER_TAB_COLS for tables owned by the current user.

ALL_TAB_COLS or DBA_TAB_COLS for tables owned by all users.

So the query will be like below.

SELECT COLUMN_NAME 
FROM ALL_TAB_COLUMNS 
WHERE TABLE_NAME = 'TableName'
ORDER BY COLUMN_ID;

For more details, please refer below link.

https://docs.oracle.com/cd/B13789_01/server.101/b10755/statviews_1179.htm