Finding the Version of the installed Oracle components

Version dependencies is a critical issue when running applications against oracle database or sometimes when you run patches etc .. the following script will let you find out the exact version of the installed oracle components

SQL> select * from product_component_version