Helpful Oracle Queries
A list of helpful Oracle queries and tips.
Returns a list of all tables (System and User)select * from all_tables;
Returns a list of all db_links (System and User)select * from all_db_links;
Returns a list of all views (System and User)select * from all_views;
Returns a list of all table columns (System and User)select * from all_tab_columns;
List current [...]