Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION n2(p_id produse.id_produs%TYPE, p_discount NUMBER, p_categorie produse.categorie%TYPE)
- RETURN NUMBER IS
- v_pret_lista produse.pret_lista%TYPE;
- v_categorie produse.categorie%TYPE;
- BEGIN
- SELECT pret_lista, categorie INTO v_pret_lista,v_categorie
- FROM produse
- WHERE id_produs=p_id;
- IF v_categorie=p_categorie THEN
- v_pret_lista:=v_pret_lista-(v_pret_lista*p_discount)/100;
- END IF;
- RETURN v_pret_lista;
- EXCEPTION
- WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.put_line(SQLERRM);
- END;
- /
- SELECT * FROM produse WHERE id_produs IN 3110;
- DECLARE
- v_pret DECIMAL(5);
- BEGIN
- v_pret:=n2(3110,5,'hardware6');
- DBMS_OUTPUT.put_line(v_pret);
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement