摘要:
写了一个函数,由于在定义时加入了 create or replace function F_计算结果(In_参数 varchar2) return number is --使用自治事务PRAGMA AUTONOMOUS_TRANSACTION; ....... 后来执行时报错: ORA-06519: 阅读全文
摘要:
1、select kd.CREATEUSERID as userid,kd.LOCATION,kd.createtime as location from KT_DEVICESTRACK kd where rownum=1 order by kd.createtime 2、SELECT * FROM ( SELECT *,ROWNUM rn FROM t ORDER BY date_col ... 阅读全文