unlock oracle user code example

Example 1: oracle unlock user

-- Unlock a user
ALTER USER my_user ACCOUNT UNLOCK;
-- If password is expired 
ALTER USER my_user IDENTIFIED BY new_password ACCOUNT UNLOCK;

Example 2: oracle unlock account

ALTER USER "MY_SCHEMA_NAME" ACCOUNT UNLOCK;