Conditions in sqlplus "define" command
610916Jun 13 2008 — edited Jun 15 2008Hi:
Had anybody tried to have a condition (something like case statement) for define command in sqlplus?
On one condition:
SQL> define var1='/db/data1/PSDMO'
on yet another condition:
SQL> define var1='/db/data2/PSDMO'
etc.
I know I could get all my values into some PL/SQL variable...but what about doing it this way?
Thanks!