Have a small glitch and hence hope you will spare me a moment.
Have a small procedure and it is not compiling. Could you just have a look and let me know why ?
Thank You, :)
Create or replace procedure proc_name IS
Create or replace FUNCTION new_password RETURN VARCHAR IS
only_alpha_characters CONSTANT VARCHAR2 (1) := 'A';
--Get a random alphanumeric string 10 characters
DBMS_RANDOM.SEED (TO_CHAR (SYSDATE, 'MM-DD-YYYY
RETURN DBMS_RANDOM.STRING (only_alpha_characters, 8);
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!