You can use && if you want to reuse the variable value without prompting the user each time.
For example: Select empno, ename, &&column_name from employee order by &column_name;