Ein kurzes Script zur Abfrage der Version von Oracle Database:
1
2
3
4
5
6
7
8
9
10
11
12
13
| #!/usr/bin/ksh
#
# Author: Ulrich Wolf - https://wolf-u.li
#
# Description: Shows the version of Oracle Database
VALUE=`sqlplus -silent "/ as sysdba" <<END
set pagesize 999 feedback off verify off heading off echo off
SELECT VERSION FROM product_component_version WHERE PRODUCT LIKE 'Oracle Database%';
exit;
END`
echo "$VALUE"
|