摘要： 实战BULK COLLECT(成批聚合类型)和数组集合type 类型is table of 表%rowtype index by binary_integer<转>: http://space.itpub.net/24546326/viewspace-672576实验目标　　使用BULKCOLLECT(成批聚合类型)和数组集合type类型实验步骤例1:批量查询部门号为"10"号的并把它们打印出来.DECLARETYPEemp_table_typeISTABLEOFmy_emp%ROWTYPEINDEXBYBINARY_INTEGER;v_emp_tableemp_table_typ 阅读全文

摘要： 型：fnd_global.apps_initialize(user_ID, Responsibility_id, Responsibility_application_id);作用：在数据库的会话中设置全局变量，和用户概要信息。参数获得：参数一，用户号 select user_id from fnd_user where user_name like '%OPERATIONS%'; -- ID of OPERATIONS：1318参数二，职责编号(responsibility id) select RESPONSIBILITY_ID, APPLICATION_ID, RESPONSIBILIT 阅读全文