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

2 votes267 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote272 views1 answer
Drop function
SQL
0 vote272 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote292 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote263 views1 answer
List mysql tables and views
SQL
2 votes283 views1 answer
Where clause for child record apex
SQL
5 votes281 views4 answers
Start postgres server
SQL
3 votes270 views2 answers
Mysql create database
SQL
1 vote275 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
7 votes265 views2 answers
Execute mysql file
SQL