Write PL/SQL code block to increment the employee’s salary by 1000 w

Write PL/SQL code block to increment the employee’s salary by 1000 whose employee_id is 102 from the given table below.

Answer»

EMPLOYEE_ID	FIRST_NAME	LAST_NAME	EMAIL_ID	PHONE_NUMBER	JOIN_DATE	JOB_ID	SALARY
100	ABC	DEF	abef	9876543210	2020-06-06	AD_PRES	24000.00
101	GHI	JKL	ghkl	9876543211	2021-02-08	AD_VP	17000.00
102	MNO	PQR	mnqr	9876543212	2016-05-14	AD_VP	17000.00
103	STU	VWX	stwx	9876543213	2019-06-24	IT_PROG	9000.00

DECLARE employee_salary NUMBER(8,2); PROCEDURE update_salary ( EMP NUMBER, salary IN OUT NUMBER ) IS BEGIN salary := salary + 1000; END;BEGIN SELECT salary INTO employee_salary FROM ib_employee WHERE employee_id = 102; DBMS_OUTPUT.PUT_LINE ('Before update_salary procedure, salary is: ' || employee_salary); update_salary (100, employee_salary); DBMS_OUTPUT.PUT_LINE ('After update_salary procedure, salary is: ' || employee_salary);END;/

RESULT:

Before update_salary procedure, salary is: 17000After update_salary procedure, salary is: 18000

Discussion

No Comment Found

Related InterviewSolutions

Write PL/SQL program to find the sum of digits of a number.
Write PL/SQL program to convert each digit of a given number into its corresponding word format.
Write a PL/SQL code to find whether a given string is palindrome or not.
Write PL/SQL code block to increment the employee’s salary by 1000 whose employee_id is 102 from the given table below.
Write a PL/SQL code to count the number of Sundays between the two inputted dates.
Write a PL/SQL procedure for selecting some records from the database using some parameters as filters.
Write a PL/SQL program using WHILE loop for calculating the average of the numbers entered by user. Stop the entry of numbers whenever the user enters the number 0.