Search Results

I forgot to close the brace after Primary_key2 and quotes for the shell variable.

Thanks for your reply.

Hi All,

I am using Unix ksh script.

I need to insert values to a table using the o/p from a slelect statement.

Can anybody Help!

My script looks like tihs.

---`sqlplus -s...

Hi

I am getting the following error when assiging it to PK_STR

a.PK1=b.PK1: not found


please help


Thanks

Thanks a lot.

Hi Thank you.

It was printing the required result.

Can you help me in assigning it to a variable.

i tried
PK_STR= echo 'PK="PK1 PK2 PK3"' |
awk -F"\"" '{split($2,s," ")
print...

It is a parameter from param file or config file u can say.
I want to use that parameter in a shell script and build the above string so that i can use it in where clause of my query.
Thanks

Hi all,

I had a typical problem.

I am using a parameter
PK="PK1 PK2 PK3"

i need to build the string

a.PK1=b.PK1 and a.PK2=b.PK2 and a.PK3=b.PK3

Please help