Oracle tables with column name

SELECT * FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- Connected user
SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- Other schemas
SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- All tables

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 vote188 views1 answer
Set mysql mode global query
SQL
0 vote193 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote231 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote198 views1 answer
Column ' ' in field list is ambiguous
SQL
3 votes148 views1 answer
System.debug apex
SQL
0 vote192 views2 answers
Sql regex vowel
SQL
0 vote188 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote192 views1 answer
Sql query to check if column contains alphabets
SQL
5 votes274 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
3 votes180 views1 answer
Oracle list user grants
SQL