Hi,
On 12.1.0.2.0 on Linux
I want to change password hash value for USER1:
SQL>alter user USER1 identified by values "nxcjhjuruink#{[";
ORA-00972: identifier is too long
I run (using single quotes):
SQL>alter user USER1 identified by values 'nxcjhjuruink#{[';
User altered.
Then with single quote in SQLPLUS it is ok.
Now I want to use execute immediate:
SQL> declare
2 begin
3 EXECUTE immediate 'ALTER USER XDB identified by values '''nxcjhjuruink#{[''';
4 end;
5 /
Again I have:
ORA-00972: identifier is too long
How can I do using execute immediate?
Thanks to help me resolve this problem.