Hi,
I'm using Oracle 8.17 on Unix.
Need to write a ksh script whose input is a few parameters and it
updates Oracle table with the parameter values using SQLPLUS.
The catch is that some of the parameters might be empty strings ("").
It that case, the existent values in the Oracle table should not be
updated.
The script should look something like:
#!/bin/ksh
sqlplus -silent "/ as sysdba" << END
UPDATE messengerLog SET stepstatus = IF ($1 = "", stepstatus, '$1')
SET failreason = IF ($2 = "", failreason, '$2')
...
commit;
exit;
END
Can you help me to formalize such a script?
Thank you,
Michael
Received on Wed Dec 08 2004 - 00:40:13 CST
