Create and drop user on oracle database

Code create user on oracle database

CREATE USER USERNAME
  IDENTIFIED BY <password>
  DEFAULT TABLESPACE TBSPACENAME
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;

Code drop user on oracle database

DROP USER USERNAME CASCADE;