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 vote122 views1 answer
Systems sql
SQL
0 vote120 views1 answer
Mysql remove last character
SQL
0 vote141 views1 answer
Multiple like values for single column postgres
SQL
0 vote105 views1 answer
Recover deleted data from mysql database
SQL
0 vote115 views1 answer
Mysql filter based on datediff
SQL
5 votes97 views1 answer
Mysql change primary key
SQL
1 vote114 views1 answer
Pgsql sum switch case
SQL
0 vote127 views1 answer
Running percentage of total postgres
SQL
5 votes125 views3 answers
Sql server utc to local
SQL
5 votes116 views1 answer
Get column name sql server
SQL