&& Substitution variable in Oracle

Bubbly
Posted by Bubbly under Others category on | Views : 6098
Double ampersand (&&) substitution variable will reuse the variable value without prompting the user everytime.

For example,
SELECT firstname,lastname,jobcode,salary,&&colname FROM employee ORDER BY &colname;

Comments or Responses

Login to post response