ORACLE密码中有特殊字符处理方法

修改t01用户的密码为test&test
SQL> alter user t01 idendified by "test&test";
Enter value for test: 
无法正常修改

下面介绍两种方法
1.
SQL> show define
define "&" (hex 26)
SQL> set define off
SQL> show define
define OFF
SQL> alter user t01 identified by "test&test";
User altered.
SQL> conn t01/test&test;
Connected.

2.
SQL> show escape
escape OFF
SQL> set escape on
SQL> show escape
escape "\" (hex 5c)
SQL> alter user t01 identified by "test\&test";
User altered
SQL> conn t01/test\&test
Connected.

上面连个参数会话断开后失效。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26794255/viewspace-1222019/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26794255/viewspace-1222019/