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 vote179 views1 answer
Postgresql find biggest table
SQL
0 vote144 views1 answer
Drush run sql select
SQL
3 votes148 views1 answer
Oracle user quota on tablespace
SQL
18 votes160 views2 answers
Sql comments
SQL
0 vote124 views2 answers
Add new column after in sql
SQL
9 votes283 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote150 views1 answer
Show table structure mysql console
SQL
0 vote137 views1 answer
Get clob size oracle
SQL
0 vote159 views1 answer
Add computed column to table sql server
SQL
65 votes321 views6 answers
Sql add column to table
SQL