Shell Programming and Scripting

hey
if you want to put your desired format in .txt file ,

then

change the following line in the script
database_retrieve_script.sh

and as earlier retriveData.sql has
then run database_retrieve_script.sh.
and then check databaseRetrieve.txt ....

hopes i understood your query ????????

Manas,

I want to store the data in this format in a .txt file:-

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

When i retrieve the data from the database i will getting the data as junk and it wont be displayed in any format.
To get the data in the above format, what i need to do ?
I need to parse the data and set it with the delimeter $.
How to do it..Pls. do help me in this..

No replies for this..Pls. do shed some light into this..It is really urgent.

Did you try the suggested solution?

Code:

$ sqlplus -s '/ as sysdba'<<!
> set pages 0 feed off echo off
> select '$'||name||'$'||age from retrieveTable;
> !
$Jason$30
$Bill$23
$Roshan$25

Thanks..When i try to use sqlplus i am getting an error saying "sqlplus : not found". sqlplus is a default command in shell script ? or we need to install it?
pls. do provide an answer for this..

No,
sqlplus is an oracle utility, not a standard shell command.
Given your question, I believe you should read the Oracle documentation first ...

rado, Can u shed some light in to this..whether i need to install sql * plus in Unix to make use of the sqlplus utility? What are the setup i need to follow? or any classpath settings? Pls. do provide some help...