随笔分类 - PL SQL
PL SQL
摘要:DECLARE l_ccid NUMBER; l_msg VARCHAR2(1000); l_chart_of_account_id NUMBER; l_set_of_book_id NUMBER; BEGIN l_set_of_book_id := fnd_profile.value('GL_SET_OF_BKS_ID'); SELECT gsob.chart_...
阅读全文
摘要:参考 http://blog.csdn.net/pan_tian/article/details/7652968#t0 Using API FND_PROFILE.save to update profile from backend 参考 http://blog.csdn.net/pan_tian
阅读全文
摘要:每次查询前清空缓存10g以上:alter system flush buffer_cache;9i:ALTER SESSION SET EVENTS 'immediate trace name flush_cache';
阅读全文
摘要:关于处理小数点位数的几个oracle函数()1. 取四舍五入的几位小数select round(1.2345, 3) from dual;结果:1.2352. 保留两位小数,只舍select trunc(1.2345, 2) from dual;结果:1.23select trunc(1.2399,...
阅读全文
摘要:SQL> select To_char(1,'000') from dual;TO_C----001注意最左边有一个空格SQL> select To_char(1,'FM000') from dual;TO_C----001注意最左边没有空格空格没有了,fm主要作用就是去除空格的影响
阅读全文