SQL query to check table size in Oracle database
In order to check size of table in Oracle database you may use following query: View the code on Gist.
Oracle
How to: check currently used credentials for database connection in Oracle SQL Developer 4
When you are using Oracle SQL Developer 4 to connect to multiple databases at the same time (sometimes using credentials other than saved in connection properties) you have multiple tabs in main window labeled with DB names without any indication of under which account you are connected to them (it seems natural to have such … How to: check currently used credentials for database connection in Oracle SQL Developer 4
Review: Oracle 12c For Dummies (For Dummies
Oracle 12c For Dummies (For Dummies by Chris Ruel\nMy rating: 4 of 5 stars For Dummies series does amazing job in explaining everything in plain language without dramatic loss of depth or excessive oversimplification. They are very good to get you started with the subject.\nMy first tech book long time ago was Networking for Dummies … Review: Oracle 12c For Dummies (For Dummies
How to: get Oracle database files location via PL/SQL query
You may use following query to get names and locations of database files: \n\n SELECT file_name,tablespace_name,bytes,blocks FROM dba_data_files ORDER BY tablespace_name,file_name Example of output you get:
How to check Oracle version via SQL query
You may use following query to check Oracle version: SELECT * FROM product_component_version Or this one: SELECT * FROM v$version Both will return Oracle version information.