datebase
寒风中游泳
开发
展开
-
ORA-01654: 索引 xxxx 无法通过 8192 (在表空间 xxxx中) 扩展
oracle报错 ORA-01654 : 查询表空间占用大小:原创 2014-06-23 14:41:22 · 5523 阅读 · 0 评论 -
mysql 自定义函数一直返回0
自己创建了一个mysql function , 如下图所示: DELIMITER $$ CREATE FUNCTION F_GET_PRICE (CURR_PRICE DECIMAL) RETURNS decimal(11,2) begin DECLARE PRICE DECIMAL(11,2) DEFAULT 0; -- 省略业务代码 SET PRICE = CURR_原创 2015-08-14 17:13:22 · 311 阅读 · 0 评论 -
pl/sql 字符编码不一致 Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different.
pl/sql连接远程数据库,登陆成功后,弹出窗口显示: Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. Character set conversion may cause unexpected results. Note: you can set the clien原创 2015-10-10 13:58:45 · 1526 阅读 · 0 评论