-
编辑 删除
oracle常用函数
--------------------------oracle常用函数|| 字符连接 initcap 首字母大写 lower 转换为小写字符upper 转换为大写lpad 左填充rpad 右填充ltrim 去除左边的空格rtrim 去除右边的空格alltrim 去除两边的空格replace 替换translate 转换ascii 求ASC码chr asc码变字符substr 字符截取函数instr 测试字符串出现的位置length 字符串的长度sysdate 系统时间add_months 添加月份,得到一个新的日期trunc 截取年月日last_day 某月的最后一天months_between 两个日期之间的月数to_char 把日期或数字类型变为字符串to_number 把字符串变成数字to_date
-
编辑 删除
ORA-12557的解决过程
ORA-12557:TNS:protocol adapter not loadableCause:On some platforms (such as OS/2) protocol adapters are loaded at run-time. If the shared library (or DLL) for the protocol adapter is missing or one of its supporting libraries is missing then this error is returned.Action:For further details, turn on tracing and reexecute the operation. The trace file will include the name of the shared library (or DLL) that could not be loaded.1. Make sure the %ORACLE_HOME%/bin directory is in your PATH. 2. Make
