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 vote226 views1 answer
Dump multiple tables mysql
SQL
2 votes254 views2 answers
Create empty table from existing table
SQL
15 votes219 views2 answers
Open postgress in terminal mac
SQL
0 vote216 views1 answer
Postgres float to int
SQL
104 votes350 views2 answers
Like in mysql
SQL
0 vote245 views1 answer
Sql quary intervewi question
SQL
0 vote325 views1 answer
Play framework connection via windows sql server
SQL
1 vote230 views2 answers
Mssql show database size
SQL
0 vote241 views1 answer
Group by join columns per table
SQL
0 vote223 views1 answer
Remove binlog mysql
SQL