Tag: replace

ORA-28221: REPLACE not specified

When a user name has a profile that has a password verify function set and the user tries to change the password using "ALTER USER" without the REPLACE clause, and also the user doesn't have ALTER USER privilege Oracle will generate the "ORA-28221: REPLACE not specified" error message. So the user needs to include the … Continue reading ORA-28221: REPLACE not specified

Regular expression

One can use the regular expressions to match in vi, grep, sed and awk. [a-d] - Match one character with in a-d i.e. a, b, c, d [^a-d] - Match one character not in the range a-d \<test\> - Match whole word test test\> - Match words that ends with test \<test\> \1ing - Match … Continue reading Regular expression