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 vote210 views1 answer
Mysql replication change database name
SQL
9 votes237 views6 answers
Oracle substring
SQL
0 vote219 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote213 views1 answer
Incorrect string value: mysql
SQL
0 vote225 views1 answer
Change magento database url usimg musql
SQL
0 vote214 views1 answer
Varchar format not case sensitive sql
SQL
0 vote220 views1 answer
Show table details postgresql
SQL
8 votes222 views1 answer
Unique vs primary key
SQL
0 vote246 views2 answers
Temp tables in sql server
SQL
2 votes224 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL