How to select table name with column name in oracle?

To select the tables which are containing particular column name, use following query. SELECT * FROM user_tab_columns WHERE column_name LIKE 'ATR%' Above query displays table names ...

How to select tablespace name with table name in oracle?

To select tablespace name which is containing specific table name in Oracle, SELECT * FROM all_tables WHERE table_name LIKE 'ORDER%' Above query searches for the table name which starts ...
© 2018 Techy Diary. All rights reserved.
Powered by Charvi Groups