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 vote178 views1 answer
Oracle drop job if exists
SQL
2 votes193 views3 answers
Sql interview query questions
SQL
2 votes171 views2 answers
Get all columns from table sql
SQL
4 votes160 views1 answer
Mac install mysql
SQL
5 votes181 views3 answers
Oracle first day of last year
SQL
5 votes170 views1 answer
Purge undo tablespace usage
SQL
6 votes185 views1 answer
Oracle pl sql source
SQL
0 vote191 views1 answer
Hour differeence in mysql
SQL
0 vote138 views1 answer
CREATE MULTIPLE FK
SQL
4 votes181 views1 answer
W3schools create table
SQL