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 vote285 views1 answer
Mysql take number in string
SQL
1 vote264 views3 answers
Drop unique key constraint in sql server
SQL
2 votes278 views1 answer
Mysql id of inserted row
SQL
0 vote241 views1 answer
Low level operator in dbms
SQL
0 vote273 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote252 views1 answer
T sql check active deadlock
SQL
0 vote257 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
29 votes248 views6 answers
Delete all rows from table mysql
SQL
10 votes295 views6 answers
Mysql set root password
SQL
0 vote272 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL