06 2014 档案
摘要:--查看在线EBS用户的相关信息SELECT PAP.FULL_NAME, FU.USER_NAME, FAT.APPLICATION_NAME, FRT.RESPONSIBILITY_NAME, FFT.USER_FUNCTION_NAME, ...
阅读全文
摘要:关于处理小数点位数的几个oracle函数()1. 取四舍五入的几位小数select round(1.2345, 3) from dual;结果:1.2352. 保留两位小数,只舍select trunc(1.2345, 2) from dual;结果:1.23select trunc(1.2399,...
阅读全文
摘要:--AP发票SELECT GJH.NAME,GJH.LEDGER_ID,GJH.JE_CATEGORY, GJH.JE_SOURCE,XDL.SOURCE_DISTRIBUTION_TYPE, XTE.ENTITY_CODE,AIDA.* FROM GL_JE_HEADERS ...
阅读全文
摘要:/u02/UAT/inst/apps/UAT_newerp3/logs/ora/10.1.3/opmn/forms_default_group_1/http://blog.csdn.net/orthon/article/details/7707067SolutionIn several custom...
阅读全文
摘要:SELECT FCPT.USER_CONCURRENT_PROGRAM_NAME, FRG.REQUEST_GROUP_NAME, FR.RESPONSIBILITY_KEYFROM FND_CONCURRENT_PROGRAMS_TL FCPT, FND_...
阅读全文
摘要:查看端口占用情况netstat -an|grep LIST|grep 15 数据库监听占用情况。netstat -an|grep 1521 1521为端口号使用如下语句kill占用端口的进程linux下杀掉占用端口的进程ps -efww|grep appltest|grep -v grep|cut ...
阅读全文
摘要:SELECT ibybanks.bank_name, --银行 ibybanks.bank_branch_name, --分行 ibybanks.bank_account_num_electronic--银行帐号 FROM ...
阅读全文