Guys,

I have a shell script that returns a value "DAY"

I want to pass this value to oracle to perform the following

Alter table AIR_GROUND truncate partition $DAY;

how do I get the value sent to the oracle script.

Any suggestions will be greatly appreciated.
Oracle LazyDBA home page