#PlSql kodu ile kullanıcı eklenmesi

[code language=”css”] CREATE OR REPLACE PROCEDURE UNI_DEV.addUser( i_username IN USERS.USERNAME%TYPE, i_password IN USERS.PASSWORD%TYPE, i_email IN USERS.EMAIL%TYPE, r_output OUT VARCHAR2) IS FUNCTION exist (column_case IN NUMBER,i_for_row IN VARCHAR2) RETURN BOOLEAN IS c_value NUMBER; v_return BOOLEAN; BEGIN IF column_case = 1 THEN SELECT COUNT(*) INTO c_value FROM users WHERE username = i_for_row; ELSE SELECT COUNT(*) INTO c_value […]