Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table emp as
select 'PRESIDENT' as job,7839 as empno,to_date('17/11/1981','dd/mm/yyyy') as hiredate,5000 as sal, 10 as deptno from dual union all
select 'MANAGER',7698,to_date('01/05/1981','dd/mm/yyyy'),2850, 30 from dual union all
select 'MANAGER',7782,to_date('09/06/1981','dd/mm/yyyy'),2450, 10 from dual union all
select 'MANAGER',7566,to_date('02/04/1981','dd/mm/yyyy'),2975, 20 from dual union all
select 'ANALYST',7788,to_date('19/04/1987','dd/mm/yyyy'),3100, 20 from dual union all
select 'ANALYST',7902,to_date('03/12/1981','dd/mm/yyyy'),3100, 20 from dual union all
select 'CLERK',7369,to_date('17/12/1980','dd/mm/yyyy'),900, 20 from dual union all
select 'SALESMAN',7499,to_date('20/02/1981','dd/mm/yyyy'),1600, 30 from dual union all
select 'SALESMAN',7521,to_date('22/02/1981','dd/mm/yyyy'),1250, 30 from dual union all
select 'SALESMAN',7654,to_date('28/09/1981','dd/mm/yyyy'),1250, 30 from dual union all
select 'SALESMAN',7844,to_date('08/09/1981','dd/mm/yyyy'),1500, 30 from dual union all
select 'CLERK',7876,to_date('23/05/1987','dd/mm/yyyy'),1200, 20 from dual union all
select 'CLERK',7900,to_date('03/12/1981','dd/mm/yyyy'),950, 30 from dual union all
select 'CLERK',7934,to_date('23/01/1982','dd/mm/yyyy'),1300, 10 from dual
14 rows affected

create table dept as 
select 'ACCOUNTANT' as dname,10 as deptno from dual union all
select 'SALES',20 from dual union all
select 'AAA',30 from dual union all
select 'BBB',40 from dual

4 rows affected

--# Notice the order for ROWNUM #--

SELECT ROWNUM, T1.*, T2.DNAME -- , T2.LOC
FROM EMP  T1, DEPT T2 
WHERE T1.DEPTNO = T2.DEPTNO
AND DNAME = 'SALES'
AND JOB NOT LIKE 'MANAGER'
ORDER BY HIREDATE DESC


ROWNUM
JOB
EMPNO
HIREDATE
SAL
DEPTNO
DNAME


4
CLERK
7876
23-MAY-87
1200
20
SALES

1
ANALYST
7788
19-APR-87
3100
20
SALES

2
ANALYST
7902
03-DEC-81
3100
20
SALES

3
CLERK
7369
17-DEC-80
900
20
SALES


SELECT T1.EMPNO, T1.SAL, 
       100 * ROW_NUMBER() OVER (ORDER BY HIREDATE DESC) as SAL_ADD
  FROM EMP T1
  JOIN DEPT T2
    ON T1.DEPTNO = T2.DEPTNO
 WHERE DNAME = 'SALES'
   AND JOB NOT LIKE 'MANAGER'
 ORDER BY T1.EMPNO                      
                   


EMPNO
SAL
SAL_ADD


7369
900
400

7788
3100
200

7876
1200
100

7902
3100
300


UPDATE EMP e 
   SET e.SAL = nvl(e.SAL,0) + 
               (
                SELECT SAL_ADD 
                  FROM
                  ( SELECT 100 * ROW_NUMBER() OVER (ORDER BY HIREDATE DESC) as SAL_ADD, 
                           T1.EMPNO 
                      FROM EMP T1
                      JOIN DEPT T2
                        ON T1.DEPTNO = T2.DEPTNO
                     WHERE DNAME = 'SALES'
                       AND JOB NOT LIKE 'MANAGER'
                    ) tt
                 WHERE e.EMPNO = tt.EMPNO )
                 
14 rows affected

SELECT T1.EMPNO, T1.SAL AS NEW_SALARY
  FROM EMP T1
  JOIN DEPT T2
    ON T1.DEPTNO = T2.DEPTNO
 WHERE DNAME = 'SALES'
   AND JOB NOT LIKE 'MANAGER'
 ORDER BY T1.EMPNO      
 


EMPNO
NEW_SALARY


7369
1300

7788
3300

7876
1300

7902
3400
ROWNUM	JOB	EMPNO	HIREDATE	SAL	DEPTNO	DNAME
4	CLERK	7876	23-MAY-87	1200	20	SALES
1	ANALYST	7788	19-APR-87	3100	20	SALES
2	ANALYST	7902	03-DEC-81	3100	20	SALES
3	CLERK	7369	17-DEC-80	900	20	SALES