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

5 votes289 views1 answer
Alter table default value mysql
SQL
0 vote348 views1 answer
Sqlite insert or update
SQL
5 votes355 views4 answers
Start postgres server
SQL
1 vote332 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote334 views1 answer
Set a default value for a column in sqlite
SQL
0 vote347 views1 answer
Mysql extract day from date leading zero
SQL
4 votes320 views1 answer
Oracle show errors compilation
SQL
1 vote343 views1 answer
Drop column if exists sql server
SQL
1 vote323 views2 answers
Setval max id postgresql sequence
SQL
0 vote390 views1 answer
Download sql file of countries names
SQL