ym563099457的博客

navicate连接oracle时报Oracle 12c ORA-28040 没有匹配的认证协议sqlnet.ora 文件增加如下内容：SQLNET.ALLOWED_LOGON_VERSION_SERVER=9SQLNET.ALLOWED_LOGON_VERSION_CLIENT=9 

oracle 存储过程中into的使用如下编译不通过：SELECT COUNT(0) into orgTotal,COUNT(DECODE(IS_ACCESS,1,1)) into orgAccessCount FROM SYS_ORGANIZATION;如下形式才行：SELECT COUNT(0) ,COUNT(DECODE(IS_ACCESS,1,1)) into orgT...

navicat连接oracle 报错：Cannot create oci environment-------------------------解决方式----------------------------本地没有安装oracle时 下载oracle clientoracle 客户端下载地址：https://www.oracle.com/database/techno...

环境变量配置NLS_LANGSIMPLIFIED CHINESE_CHINA.ZHS16GBK设置好环境变量即可

plsql连接oracle时报错 错误描述:Initialization errorSQL*Net not properly installedOracleHomeKey:OracleHomeDir:------------------------------------下载：instantclient_11_2解压到相应目录，plsql developer...

oracle最近一周、最近一月sql：最近一周：SELECT to_char (SYSDATE- LEVEL + 1, 'yyyy-mm-dd') createTime FROM DUAL connect BY LEVEL <= 7最近一月：SELECT to_char (SYSDATE- LEVEL + 1, 'yyyy-mm-dd') ...

大量并发连接 oracle时报错：Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off查询数据库进程数上限：select value from v$parameter where name =‘processes’; 查询实际连接数：...

DECLARE    re float(8);BEGIN    PROC_REPORT('201811',re);END;

navicate连接oracle报错：用户名/口令无效; 登录被拒绝首先给用户赋予sysdba权限：grant dba to username;给用户重新设置密码：alter user abc identified by 123456重新用navicate连接 ...

导出表：plsql :工具--导出用户对象导出数据：工具--导出表‘注意要选择可执行文件dmp文件导出时一直显示：正在执行oracle导出程序,请等待 请’配置oracle环境变量...