Oracle

How to check object owner in Oracle DB

Just a quick note on how to check object owner in Oracle database. Following query can be used: Note that it requires access to ALL_OBJECTS view which is normally requires DBA rights.

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.