To find all versions mentioned in RMS/WMS forms

strings -a hh_nsc_receiving_s.fmb awk '(/^\*/ && /[0-9]\.[0-9]+/) /Name/'

Note: only for Oracle Forms used in Oracle Retail.

Ways to get sql query output inside UNIX Shell Script

Below are different ways to get SQL query output inside unix shell script.

Method 1:
{
/bin/echo "set pause off"
/bin/echo "set pagesize 0"
/bin/echo "set linesize 300"
/bin/echo "set feedback off"
/bin/echo "set echo off"
/bin/echo "set term off"
/bin/echo "SELECT location_id
FROM location
WHERE facility_id = 'W1';"
} | sqlplus -s dbuser/dbpwd