oracle tables with column name

Solutions on MaxInterview for oracle tables with column name by the best coders in the world

showing results for - "oracle tables with column name"
Jodi
01 Sep 2020
1SELECT * FROM USER_TAB_COLS WHERE TABLE_NAME = 'my_table';
2SELECT * FROM ALL_TAB_COLS WHERE TABLE_NAME = 'my_table';
3SELECT * FROM DBA_TAB_COLS WHERE TABLE_NAME = 'my_table';
Julia
12 Jun 2018
1SELECT * FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- Connected user
2SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- Other schemas
3SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN';	-- All tables
queries leading to this page
list all tables with column name oracleoracle sql select table column namesoracle select all with table namehow to find all tables name in oracle 19csql find tables with column nameget all tables with column name sqlfind table name using column name in sql serversql server find tables nameoracle select all tables where column namefind table with column name oraclehow to find all table names in oraclehow to find table name using column name in oracleoracle find table nameselect oracle table columnsfind tables with column name in oracleoracle columns tableoracle get table column namessql find column name in all tablesfind the table name in sql serverfind all tables a field is in oracletable name that comes with oracle sql how to find table name with column name in sqlfind all tables with column namequery to find table with column name in oracleoracle get table namesoracle sql get all table namesselect table data with table name in column oraclefind table name from column name in sqloracle get all column names from tablewhat is table name that comes with oracle sqlmssql search for column name in all tablesfind all tables with column name in sql serverget table nameoracle select all tables namesoracle get all tables with column namefind column name of table in sqlquery to find table using column nameoracle search all tables for a column namehow to find table name in sql with column namefind table from column name in sql serverfind all column names in oracle tableoracle select all table namesfind sql table with column name oracle select all tables where column name likesql find all tables that have a column name isdeletedsql find tables with column name sql serverselect all tables names in oracle databaseget table names in oraclequery to find table with column names in oraclesearch sql tables for column namehow to get all column names of a table in oracleoracle get all table columnsselect table name oracleoracle tables with column namehow to get all table names in oraclecheck all tables name on oracle dbin sql find column names from tablesoracle find all tables with column valueoracle sql find table namestable data with column name oraclefind the table name with column name in sqlfind table with column nameoracle find all tables with column nameselect all tables columns oraclehow to find all table name using column in sqlhow to find all tables in oracle with a column name how to find the table name using column value in oracleoracle sql query that returns all tables that have a specific column namesql find table with column namesql script to find column name in database tablesselect all tables with specific column name oracleoracle query table column syntaxoracle select all columns with table nameoracle tables with column name