I would like to pass parameters to a sqlscript with the &&
so that one variable is defined for the entire script
sqlplus scott/tiger @script foo
I tried everything and read and still it prompts me for the foo
variable... sometimes it does work ( set verify off ) and just
gives me the results... in others how do I pass variables
to a sql script through sqlplus without having sqlplus prompt
me for what the variable is, especially since I pass it.
Thanks