Wk8-in-class-weds

gistfile1.txt

CREATE OR REPLACE FUNCTION inCart (Product_ID IN VARCHAR2) RETURN BOOLEAN
IS 
    doesExist boolean := false;
    matches number := 0;
BEGIN
    select count(nest.PRODUCT_ID) into matches from SHOPPING_CARTS carts, table(carts.cart) nest;
    IF matches > 0
    THEN
        doesExist := true;
    END IF;
    RETURN doesExist;
END;

--https://stackoverflow.com/questions/40124414/dbms-output-cannot-print-boolean
BEGIN
   dbms_output.put_line(sys.diutil.bool_to_int(
    INCART('100')
   ));
END;