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 vote177 views1 answer
Search for replace in mysql
SQL
2 votes179 views1 answer
Mysql increment value by 1 in update
SQL
0 vote200 views1 answer
Postgre query date
SQL
1 vote131 views1 answer
Metada in sql
SQL
0 vote179 views1 answer
Mysql count with two joins
SQL
0 vote178 views1 answer
We are intrested to work with your organization
SQL
2 votes185 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
7 votes181 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote178 views2 answers
Postgresql get last day of month
SQL
0 vote186 views1 answer
Mysql server not running
SQL