Shell Programming and Scripting

Hi,

I have a shell script that returns 10 records for the column Name and age from a select query. Where when i store those data in retrieve_list.txt file i need to store the data in a particular format like:-

$Jason$30
$Bill$23
$Roshan$25

Here is my script:

1) database_retrieve_script.sh
-------------------------------


#!/bin/ksh

LOGFILE="databaseRetrieve.log"
USER="myuser"
PASS="mypass"
SID="sampledb"

sqlplus -s ${USER}/${PASS}@${SID} << EOF >${LOGFILE} 2>&1
whenever oserror exit 98;
whenever sqlerror exit 99;
@retriveData.sql
exit 140;
EOF
SQL_DATA="$?"
if [ "$?" -ne 140 ]
then
echo "Connection error (Oracle down?)"
else
echo "Connection estabilished, script executed."
${SQL_DATA} > retrieve_list.txt
fi


2) retriveData.sql
------------------------
#!/bin/ksh

select * from retrieveTable;

Here the script will get the whole data and won't store it
in the above format.I want the data to be stored in the above format.Pls. do help me in this.It is urgent...

Thanks

kindly change your retriveData.sql

as follows,

HTML Code:

select '$'||ColumnName1||'$'||ColumnName2 from <retrieveTable>;

Thanks Manas... But how i will get the data in the format i want..Pls. do help me in this.

Pls. do reply on this to get the data in above format.

U can use the the query as provided in ur sql file "@retriveData.sql" and then call the shell script.

- If there are some error/exception or whatever is the difference in the output vs expected, please specify

Thats right... I can get the data(Name,Age) from the select query but i need to organize the data in a particular format. Like:

$Jason$30
$Bill$23
$Roshan$25

and save those data into a file. Here my question is that how to organize the data in the above format after getting the data from the query? Pls. do help me...

Pls. do reply i am finding it difficult to store the data in above format in a .txt file..Pls. do help me in this. It is urgent...