SQL PLUS control and command line variables

From: David Alexander VanHorn <dvanhorn_at_emba.uvm.edu>
Date: Wed, 20 Mar 2002 19:43:34 -0500
Message-ID: <Pine.GSO.4.20.0203201941520.28578-100000_at_mansfield.emba.uvm.edu>

[Quoted] I am trying to write a SQL PLUS script that checks the value passed on the command line and then takes appropriate action, something like this psuedo code...

if &1 == foo
_at__at_fooscript

else if &1 == bar
_at__at_barscript

But I don't see how this can be accomplished in sql plus. Are there even any control structures available (ie "if" or an equality operator) in sql plus?

ideas?

Thanks,
David Received on Thu Mar 21 2002 - 01:43:34 CET