[ORACLE/PLSQL] Using the single ampersand substitution variable : &

The single ampersand (&) substition variable causes Oracle to stop and prompt the user for a value before executing the command. This si a very good tool when the developer wants to use the same query to retrieve  different set of data

Example :

SELECT &colname FROM &tabname WHERE &colname IS NOT NULL;

Result: