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

1 vote274 views1 answer
Alphabetical order mysql
SQL
0 vote264 views1 answer
Dnsmasq.conf location macos
SQL
1 vote285 views1 answer
How to lock table in mysql
SQL
0 vote269 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
1 vote262 views1 answer
Not exists mysql
SQL
0 vote261 views1 answer
Sql remove last x char
SQL
1 vote264 views1 answer
Count of tables in database mysql
SQL
2 votes261 views1 answer
Sql ignore accents
SQL
1 vote274 views1 answer
Alter add syntax
SQL
1 vote278 views1 answer
Oracle extract minute from date
SQL