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 vote124 views1 answer
Hive batch drop table
SQL
13 votes134 views2 answers
Sql join
SQL
-1 vote136 views1 answer
Default username and password for oracle 11g
SQL
0 vote117 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote144 views3 answers
Join
SQL
8 votes150 views1 answer
Alter tablespace add datafile autoextend
SQL
6 votes120 views2 answers
Mysql concatenate two columns into one
SQL
0 vote119 views1 answer
Sql change primary key to composite key
SQL
0 vote118 views1 answer
Mysql group rows with same value
SQL
-1 vote77 views1 answer
How to create script to connect to oracle database and run query
SQL