Database Reference
In-Depth Information
Figure 6-1 . Control Center About System window showing database version and information
If you don't have access to connect directly to the instance, you can run a query
against the database instead to pull the same information. A sample query that shows
this information can be seen in Listing 6-1 ; the results are shown in Figure 6-2 .
Listing 6-1 . Sample Query to Show Database Version and Information
SELECT inst_name
, release_num
, service_level
, bld_level
, ptf
, fixpack_num
FROM TABLE (sysproc.env_get_inst_info())
Figure 6-2 . Query results showing database version and information
 
 
 
 
Search WWH ::




Custom Search