SQLize | PHPize | SQLtest

CREATE FUNCTION get_bal(acc_no IN NUMBER) RETURN NUMBER IS acc_bal NUMBER(11,2); BEGIN SELECT order_total INTO acc_bal FROM orders WHERE customer_id = acc_no; RETURN(acc_bal); END; / CREATE PROCEDURE remove_emp (employee_id NUMBER) AS tot_emps NUMBER; BEGIN tot_emps := tot_emps - 1; END; / CREATE OR REPLACE FUNCTION p_cpu_loop_f(p_iterations integer) RETURNS integer AS $function$ DECLARE i integer := 0 ; BEGIN WHILE i <= p_iterations LOOP i := i + 1 ; END LOOP; RETURN i; END ; $function$ LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE; CREATE TABLE start_q AS SELECT now() AS s; SELECT p_cpu_loop_f(10000000); SELECT now() - (SELECT s FROM start_q);