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 vote138 views2 answers
Oracle difference between two dates in seconds
SQL
2 votes149 views3 answers
Mysql pass command from command line
SQL
0 vote127 views1 answer
Get who is hired in month in sql
SQL
0 vote140 views1 answer
Print boolean in plsql
SQL
0 vote168 views1 answer
Sort by
SQL
1 vote149 views1 answer
Postgresql define pk sequence next number
SQL
0 vote135 views1 answer
User defined variables in sql
SQL
3 votes188 views1 answer
Sql several or
SQL
0 vote132 views1 answer
Sqlite to csv statement
SQL
0 vote190 views1 answer
Oracle show running job
SQL