oracle 默认escape_在oracle中设置转义字符(set escape character in oracle)

最新推荐文章于 2022-09-21 09:50:16 发布

weixin_39633455

最新推荐文章于 2022-09-21 09:50:16 发布

阅读量160

点赞数

文章标签： oracle 默认escape

本文链接：https://blog.csdn.net/weixin_39633455/article/details/111515502

版权

I'm working on a Java program that try to reset a user's password in oracle and sql-server. This password is a random generated password that will have some character that is not acceptable as a normal string. Eg. ',"",;

The command that I'm using to reset user's password is :

oracle: ALTER USER IDENTIFIED BY

sql-server: ALTER LOGIN WITH PASSWORD = ''

How can I do this reset so that it can accept all kind of special character?

I did google and found out about quoting method:. Also I did found out about using single code and double code. But what if the password generated have a " or same quote delimiter inside that password? Then it will be a problem.

Eg. IDENTIFIED BY 'jks'k"fjh''d'

Eg. password = q[#kkksdj#jsksls#]

Eg. password = "nm.js""kh:kjhs"

Is there any way for me to do this inside the oracle and sql-server? Or do I need to escape each character one by one from java before sending to oracle/sql-server? My reset program for oracle and sql-server are different. So the method can be different.