Shell Programming and Scripting

$ cat script.sh

sql_output="Brad,123,xyz"

name=$(echo $sql_output | cut -d',' -f1)
no=$(echo $sql_output | cut -d',' -f2)
id=$(echo $sql_output | cut -d',' -f3)

echo "Your name is $name and your id is $id"

$./script.sh

Your name is Brad and your id is xyz

#!/bin/bash  

sqlplus CTEMEA_BM04/payplus1@LOADTST   << EOFSQL
     SELECT *
      FROM (select  mif.mid from mif order by mif.mid desc)
      WHERE rownum < 2
      ORDER BY rownum;
EOFSQL

#!/bin/bash
 
ret=`sqlplus -s CTEMEA_BM04/payplus1@LOADTST << EOFSQL
SELECT *
FROM (select mif.mid from mif order by mif.mid desc)
WHERE rownum < 2
ORDER BY rownum;
EOFSQL`
 
echo $ret

#!/bin/ksh
#set -xv
db_connection="CTEMEA_BM04/payplus1@LOADTST"

db_con()
{
	sqlplus -s $db_connection <<EOFSQL
	set pagesize 0
	set head off
	set feedback off
	${1}
EOFSQL
 }
 
MID=`db_con "SELECT * FROM (select mif.mid from mif order by mif.mid desc) WHERE rownum < 2 ORDER BY rownum;"`





echo $MID