Application of PL/SQL to ERP auto-recall system development
LU Jing-yun · Journal of Nanjing University of Technology · 2006
In the development of a complex database system,traditional SQL language can not be used to intricate conjunction or will fall short of perfect response rate.Thus in the process of developing ERP for auto recalling query system used in a big auto manufacture company,the primary BAAN system (ERP system) was pretreated and conformed with auto recalling demand,and the query system with fast respondency was developed.The system provides optimized scheme,which can not only use PL/SQL to establish middle-pretreatment table,but also make use of dmbs_job bag for pretreatment timely,and it can be applied to different kinds of complicated conjunction query with little time delay and the increasing of robustness of the system performance.