Output:
(1 rows affected) (3 rows affected) (1 rows affected) (1 rows affected) (1 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 100 SACHIN CLERK 4000.0000 2021-11-03 102 RAHUL MANAGER 6000.0000 2020-05-10 103 STALIN DATA ENGINEER 58000.0000 2023-04-15 107 Stanly clerk 10000.0000 2020-12-31 104 Sathish trainee 14000.0000 2023-02-20 105 Suresh NULL NULL 2023-02-20 200 pavan NULL NULL 2019-12-02 (7 rows affected) ename sal ---------- ------------ SACHIN 4000.0000 RAHUL 6000.0000 STALIN 58000.0000 Stanly 10000.0000 Sathish 14000.0000 Suresh NULL pavan NULL (7 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 103 STALIN DATA ENGINEER 58000.0000 2023-04-15 (1 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 100 SACHIN CLERK 4000.0000 2021-11-03 103 STALIN DATA ENGINEER 58000.0000 2023-04-15 107 Stanly clerk 10000.0000 2020-12-31 104 Sathish trainee 14000.0000 2023-02-20 105 Suresh NULL NULL 2023-02-20 (5 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 103 STALIN DATA ENGINEER 58000.0000 2023-04-15 (1 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 100 SACHIN CLERK 4000.0000 2021-11-03 102 RAHUL MANAGER 6000.0000 2020-05-10 (2 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 100 SACHIN CLERK 4000.0000 2021-11-03 103 STALIN DATA ENGINEER 58000.0000 2023-04-15 107 Stanly clerk 10000.0000 2020-12-31 104 Sathish trainee 14000.0000 2023-02-20 105 Suresh NULL NULL 2023-02-20 (5 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 102 RAHUL MANAGER 6000.0000 2020-05-10 200 pavan NULL NULL 2019-12-02 (2 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 100 SACHIN CLERK 4000.0000 2021-11-03 102 RAHUL MANAGER 6000.0000 2020-05-10 107 Stanly clerk 10000.0000 2020-12-31 (3 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 100 SACHIN CLERK 4000.0000 2021-11-03 103 STALIN DATA ENGINEER 58000.0000 2023-04-15 107 Stanly clerk 10000.0000 2020-12-31 (3 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 100 SACHIN CLERK 4000.0000 2021-11-03 102 RAHUL MANAGER 6000.0000 2020-05-10 104 Sathish trainee 14000.0000 2023-02-20 (3 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 107 Stanly clerk 10000.0000 2020-12-31 (1 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 107 Stanly clerk 10000.0000 2020-12-31 104 Sathish trainee 14000.0000 2023-02-20 (2 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 102 RAHUL MANAGER 6000.0000 2020-05-10 107 Stanly clerk 10000.0000 2020-12-31 (2 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 103 STALIN DATA ENGINEER 58000.0000 2023-04-15 104 Sathish trainee 14000.0000 2023-02-20 105 Suresh NULL NULL 2023-02-20 (3 rows affected) empid ename job sal hiredate ------ ---------- -------------------- ------------ ---------------- 104 Sathish trainee 14000.0000 2023-02-20 105 Suresh NULL NULL 2023-02-20 (2 rows affected)