Oracle columns table

SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table';
SELECT * FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table';
SELECT * FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table';

Similar codes

0 vote343 views1 answer
Alternative for LIMIT sql
SQL
1 vote300 views1 answer
Mysql current time
SQL
4 votes266 views2 answers
Select todays data postgres query
SQL
0 vote309 views1 answer
How to find lowest in sql
SQL
2 votes337 views2 answers
Create table mysql integer NOT null
SQL
10 votes289 views2 answers
Forgot my mysql password mac
SQL
3 votes277 views1 answer
Sql multiple column index
SQL
0 vote290 views1 answer
Varchar format not case sensitive sql
SQL
1 vote293 views1 answer
Show structure of table in sql
SQL
0 vote275 views1 answer
Mssql describe stored procedure sqlcmd
SQL