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 vote203 views1 answer
Oracle lowercase
SQL
0 vote207 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote188 views1 answer
Sum values by month mariadb
SQL
2 votes260 views3 answers
Xampp mysql database not starting
SQL
0 vote152 views1 answer
Mysql select top 2
SQL
1 vote188 views1 answer
Oracle create as select
SQL
0 vote186 views1 answer
Sql if else in select
SQL
13 votes266 views3 answers
Sql select from multiple tables without join
SQL
1 vote181 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote188 views1 answer
Sql where part of string match
SQL