& 作为密码 oracle

还有一种可能性是在SQLPLUS或者其他IDE(例如PL/SQL DEVELOPER下)存在&(AND)符号时，客户端将&理解为变量，如： SQL> create user maclean_password1 identified by "0000&a"; Enter value for a: 此时只需要将define修改为非&的其他符号即可，例如：

SQL> set define +

SQL> show define define "+" (hex 2b)

SQL> create user maclean_password1 identified by "0000&a"; User created.

SQL> grant connect to maclean_password1;

Grant succeeded.

SQL> conn maclean_password1/"0000&a" Connected.

SQL> set define +
SQL> set define +
SP2-0317: expected symbol name is missing
SQL> alter user rick identified by "Ods&Report_2022";

User altered.

SQL> show define;
define "+" (hex 2b)
SQL> set define +
SP2-0317: expected symbol name is missing
SQL> set define +
SP2-0317: expected symbol name is missing
SQL> set define .
SQL>