Using a single command sequence, write the SQL code that will change the project number (PROJ_NUM) to 18 for all employees whose job classification (JOB_ CODE) is 500.

Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing

HOW TO FIX THIS CODE IN ORACLE SQL ?CREATE OR REPLACE PROCEDURE CONVERT_VAL(V1 VARCHAR,V2 VARCHAR,AMT NUMBER) IS val VARCHAR2(100); val1 VARCHAR2(2); val2 varchar2(2); amount number;    DECLARE      meter NUMBER := 0;       Cem NUMBER := 0;   BEGIN    val1:=v1;    val2:=v2;    amount:=amt;    Select case when val1!=val2 then                           case                          when lower(val1)='km'       meter := km * 1000;      Cem := meter * 100;      dbms_output.Put_line('The value of KM NUMBER KM to meters is: ' ||meter);      dbms_output.Put_line('The value of KM NUMBER KM to centimeters is: ' ||cem);  when lower(val1)='m'      dbms_output.Put_line('The value of M NUMBER M to KM is: ' ||KM);      dbms_output.Put_line('The value of M NUMBER M to centimeters is: ' ||cem);        when lower(val1)='Cm'      dbms_output.Put_line('The value of M NUMBER CM to KM is: ' ||KM);      dbms_output.Put_line('The value of M NUMBER CM to M is: ' ||M);      else                           'same…