Question on Shell Script
 

Hi,
I am having a shell script with similar content as shown below.

export ORACLE_HOME1=${data.GI_ORACLE_HOME_LOC}
export ORACLE_HOME2=${data.DB_ORACLE_HOME_LOC}
export USERNAME=${data.EMUserName}

Now I want to know what are other variables that are available as part of "data" data set and display all. Can some one show me the way on how to do the same? Thanks a lot for your time and help in this regard.

Hi,

the "env" command will list all currently defined shell/environment variables (for bourne style shells).

Evo2.

Reading carefully, this is an Oracle question.

You can also look at an Oracle forum.

I think that it is "set" within the oracle prompt.

OK

Hi,
Good catch: shell variables can't contain ".". However, the OP explicitly says it is a shell script...

Evo2.

I'm assuming you want to use the value in the shell variables as parameters for a database enquiry? Well then, what's the command you want to use for doing it with a single entry?

Configure that, then wrap a loop around it and substitute the variables you want to use as the inputs.

However, you'll probably want to use an array for the shell script instead of single variables. Perhaps even an associative array.

Hi,
Thanks for all your responses. I found the answer and my question was mis-leading I suppose. Actually it was Java procedure which has the variable value assigned and within java procedure shell script is called and hence variables are passsed internally. Any ways thanks for your time & response.

Regards,
Manick.