Abfrage der Version von Oracle Database per KSH-Shell-Script

 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"