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 vote328 views1 answer
Mysql show current queries
SQL
15 votes363 views7 answers
MYSQL
SQL
0 vote308 views1 answer
Create bakupd database sqlserver
SQL
1 vote320 views1 answer
Mysql select row with max value group by
SQL
2 votes356 views2 answers
Install postgresql
SQL
0 vote420 views1 answer
Oracle calculate statistics on partition
SQL
5 votes364 views3 answers
Mysql update field from one table to another
SQL
0 vote348 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote378 views1 answer
Sql: extract day text from datetime value
SQL
11 votes338 views4 answers
Round in sql
SQL