http://www.unix.com – Code: check_build_info_table() { if [ $DB_SYSTEM = "ORACLE" ] then export build_info_table=`sqlplus -s sna/dbmanager <<! set pagesize 0 heading off feedback off SELECT DISTINCT TABLE_NAME FROM ALL_TABLES WHERE OWNER = 'XYZ' AND TABLE_NAME = 'MY_TABLE'; exit !` elif [ $DB_SYSTEM = "MYSQL" ] then (HowTos)