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

The UNIX CD Bookshelf

UNIX Power Tools
UNIX in a Nutshell: System V Edition
Learning the vi Editor
sed & awk
Learning the Korn Shell
Learning the UNIX Operating System

above online books are available at http://doc.novsu.ac.ru/oreilly/unix/index.htm

Unix Vi Commands

list of vi commands at
http://spreadsheets.google.com/pub?key=pekeaZVmTcB2YJBisxgDnHw