Question: Which good programming practice guideline would make this code easier to read? DECLARE v _ sal NUMBER ( 8 , 2 ) ; BEGIN SELECT

Which good programming practice guideline would make this code easier to read?
DECLARE
v_sal NUMBER(8,2);
BEGIN
SELECT salary INTO v_sal
FROM employees WHERE employee_id =100;
UPDATE employees
SET salary = v_sal;
END;
Using a consistent naming convention for variables
Indenting each level of code
Declaring variables using %TYPE
Avoiding implicit data type conversions choose one answer only

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!