oracle tables with column name 1

oracle tables with column name

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';

Here is what the above code is Doing:
1. The first query is looking at the columns in the table that you own.
2. The second query is looking at the columns in the table that you have access to.
3. The third query is looking at the columns in the table that are in the database.

Similar Posts