## ksh - awk examples
## ksh_awk_examples.txt

## awk: extract a specific column from a line (in this case the 1st column) with a delimiter of /product
echo $ORACLE_HOME | awk -F"\/product" '{print $1}'  

## extract a specific column from a line (in this case the 2nd column)
| awk '{print $2}' 

## awk: display lines starting with the drop litteral
awk '$0 ~ /^drop/ {print $0 }' drop_users.sql > test.sql