ORACLE SQL - I have this code and I am getting the error message that there is an error near: WHERE SQR_FT > '1500';   INSERT INTO PROPERTY      (office_num, address, sqr_ft, bdrms, floors, monthly_rent, owner_num) vALUES      (office_num_val, address_val, sqr_ft_value, bdrms_value, floors_value, monthly_rent_value, owner_num_value) WHERE SQR_FT > '1500';

Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).

Create a Pl SQL package named EMP_PKG which will have the above three functions and procedures as follows:  CALC_TAX - private CHECK_FNAME - Public AVG_SAL - Public

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…