ˉ-_lishk_-ˉ

【应用场景】下面这样一个SQL语句在编辑页面，想要快速转换成java或者其他开发语言的拼接形式：select b.bm, b.bmmc from sys_bmmx b where b.fbm = '1'目标格式StringBuffer sql=new StringBuffer();sql.append("select b.bm, b.bmmc from sys_bmmx b ");...

打开PL/SQL 弹出如下提示：Database character set (ZHS16GBK) and Client character set (AL32UTF8) are different.Character set conversion may cause unexpected results.Note: you can set the client character set...

select * from user_objects where (object_type='TABLE') and (created > sysdate -45);