If you mean in SQL*Plus, then & and && are for substitution variables. If you use a single & then the value will be prompted for each time it's encountered. IF you use && then the original substitution value is used for the duration of the script
answered Jan 13, 2010 at 12:55 PM
The & operator means that the PL SQL block requires user input for a variable. The && operator means that the value of this variable should be the same as inputted by the user previously for this same variable.
answered Jan 25, 2010 at 07:23 AM