By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
BANNER | BANNER_FULL | BANNER_LEGACY | CON_ID |
---|---|---|---|
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 |
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production | 0 |
6 rows affected
5 rows affected
SSN | SALARY |
---|---|
1011 | 1000 |
1012 | 1200 |
1013 | 1300 |
1014 | 1400 |
1015 | 1500 |
1015 | 1600 |
1 rows affected
ORA-01403: no data found
ORA-06512: at "FIDDLE_TEWXKMPBKZFLDBKTAQVL.INCREASE_SALARY_FOR_EXCESSIVE_HOURS", line 13
ORA-06512: at line 2
1 rows affected
ORA-01403: no data found
ORA-06512: at "FIDDLE_TEWXKMPBKZFLDBKTAQVL.INCREASE_SALARY_FOR_EXCESSIVE_HOURS", line 13
ORA-06512: at line 2
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "FIDDLE_TEWXKMPBKZFLDBKTAQVL.INCREASE_SALARY_FOR_EXCESSIVE_HOURS", line 15
ORA-06512: at line 2
SSN | SALARY |
---|---|
1011 | 1100 |
1012 | 1200 |
1013 | 1430 |
1014 | 1400 |
1015 | 1500 |
1015 | 1600 |
1 rows affected
dbms_output:
*** Before Procedure call:
Employee_ssn :1011
Employee_sal :1000
Work_hours :60
*** After Procedure call:
Employee_ssn :1011
Employee_sal :1100
Work_hours :60
1 rows affected
dbms_output:
*** Before Procedure call:
Employee_ssn :1012
Employee_sal :1200
Work_hours :40
No data found.
1 rows affected
dbms_output:
*** Before Procedure call:
Employee_ssn :1013
Employee_sal :1300
Work_hours :70
Employee_ssn :1013
Employee_sal :1300
Work_hours :65
*** After Procedure call:
Employee_ssn :1013
Employee_sal :1430
Work_hours :70
Employee_ssn :1013
Employee_sal :1430
Work_hours :65
1 rows affected
dbms_output:
*** Before Procedure call:
No data found.
1 rows affected
dbms_output:
*** Before Procedure call:
Employee_ssn :1015
Employee_sal :1500
Work_hours :80
Employee_ssn :1015
Employee_sal :1600
Work_hours :80
Many rows fetched.