Single Ampersand Substitution

Single Ampersand Substitution Varibales
      A substitution variable is prefixed by a single ampersand(&) and a value is assigned it.

Ex:-    Select empno,ename,sal from emp where
           deptno=&department_number;
          select ename,deptno,sal*12 from emp where job=’&Designation’;
           select deptno,&Arthametic_expression from emp;
           select * from emp where &Condition_please;
           select ename,job,&rem from emp order by &rem;
            select empno,ename,sal from emp where job=’&1’;
             save job1
             start job1 CLERK;

                   select &rest;

For
Online Classes

Contact Us: +919885348743