• Quoting password for user in Oracle database

    Recently I needed to create a user in Oracle11g database and I was surprised that for other people following expression works well: CREATE USER name IDENTIFIED BY password But I'm constantly getting ORA-00922: missing or invalid option error. Quoting the password solves the problem, so following expression works fine: CREATE USER name IDENTIFIED BY "password" It turned out that for password which contain only digits or start with a letter quotes aren't needed, so first expression works fine.