且听风吟的专栏

1.下载oracle客户端https://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html我下载的版本是instantclient-basic-windows.x64-12.2.0.1.0.zip ,下载后解压到本地硬盘，我放到了：D:\Program ...

PLSQL Developer 13.0.0.1883 注册码product code： 4vkjwhfeh3ufnqnmpr9brvcuyujrx3n3leserial Number：226959password: xs374ca转自：https://blog.youkuaiyun.com/adosea/article/details/86136094...

用pl/sql导入excel中文乱码，一般是客户端和服务端的编码不一致。1、先查看数据库编码select userenv('language') from dual;2、设置客户端环境变量变量名：NLS_LANG变量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK注意：变量值设置成前面查出的数据库的编码3、重启客户端...

--TypeCREATE OR REPLACE TYPE zh_concat_im AUTHID CURRENT_USER AS OBJECT(CURR_STR clob,STATIC FUNCTION ODCIAGGREGATEINITIALIZE(SCTX IN OUT zh_concat_im)RETURN NUMBER,MEMBER FUNCTION ODCIAG...