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