Can we use an ampersand (&) character in the subquery of a SELECT statement ?
THX
Ex. SELECT ename, empno, sal
FROM emp
WHERE deptno = (SELECT deptno
FROM dept
WHERE UPPER(loc) = UPPER('&loc'))
Printable View
Can we use an ampersand (&) character in the subquery of a SELECT statement ?
THX
Ex. SELECT ename, empno, sal
FROM emp
WHERE deptno = (SELECT deptno
FROM dept
WHERE UPPER(loc) = UPPER('&loc'))
In sqlplus, sure.
we can use it any where ,it just helps us in dynamic usage of variable(run time usage of vairable) its not related with queries .
Thanks
lnr