SET HEAD ON
SET VERIFY OFF
col instance_name form a8 Heading "Instance"
col name form a8 Heading "DB Name"
col host_name form a12 Heading "Hostname"
/* ,open_mode - v8i only */
from v$database, v$instance;
Try this script, I put it on all my boxes (Unix and NT) as a quick reference. I named it NAME.SQL this way all I have to do is type name at a SQL prompt and I will know what instance I am logged into. If you support multiple instance this is a real timesaver. Beats the heck out of ..
SQL> select * from global_name;
Ps. I think I stole this script from this webpage.
Unfortunatly, it does show what I want. It does show version 22.214.171.124.1, but I'm still not able to verify that the patch was successfully installed. I guess I just have to go on faith that the patch was successful if my DB doesn't crash. (Which is a huge leap of faith being that we are talking about Oracle Corp.)