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

3 votes362 views2 answers
Current year sql
SQL
0 vote358 views1 answer
Get current date data in mysql
SQL
3 votes393 views2 answers
Truncate table
SQL
0 vote346 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote345 views1 answer
Laravel eloquent get generated sql
SQL
1 vote358 views1 answer
Error code 1292 mysql workbench
SQL
0 vote370 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote315 views1 answer
Psql show with user is logged in
SQL
3 votes376 views1 answer
Postgresql if null then 0
SQL
0 vote352 views2 answers
Sql server select first day of previous year
SQL