摘要： var OnInit;var OnNodeChecked;function initchecknode(TreeView1){ //获得需要初始化选择状态的节点的字符串. var selectedNodes = document.getElementById("corpList").value; var arrayNodes = new Array(); arrayNode... 阅读全文

摘要： 阅读全文

摘要： 包头： create or replace package GetMonthPlan is TYPE T_MonthPlan IS REF CURSOR; Procedure p_GetMonthStockPlan(sYear in varchar, sMonth in varchar, ... 阅读全文

摘要： --创建记录 TYPE REC_PERSON IS RECORD( PersonSID varchar2(50), PersonName varchar2(60), Gender varchar2(10), DepartSID varchar2(50), IsSaler char(1), IsAgent char(1), IsDel... 阅读全文

摘要： sSQL := 'alter session close database link ' || sDataSource; execute immediate sSQL; 阅读全文

摘要： TYPE V_CUR IS REF CURSOR; CUR V_CUR;open CUR for sSQL; LOOP FETCH CUR INTO R_PERSON; EXIT WHEN CUR%NOTFOUND; i := i+ 1; table_person_list(i) := R_PERSON; END LOOP; CLOSE CUR; 阅读全文

摘要： select NVL(count(Sequence_Name), 0) into nCount from all_sequences where Sequence_Owner = 'LSP' and Sequence_Name = 'SEQ_SHELFID'; if nCount > 0 then sSQL := 'drop sequence LSP.SEQ_SHE... 阅读全文

摘要： for cura in (select DeptId,parentId from lsp.lbi_department where parentId = curId order by DeptId) loop insert into TMP_TEST(id,parentId) values(cura.id,cura.parentId); Insert... 阅读全文

摘要： select count(*) into nCount from user_tables where table_name = 'TT_DEPARTPERSONRELATION';sSQL := 'Create global temporary table TT_DepartPersonRelation( DepartSID varchar2(50), Pers... 阅读全文

摘要： update f_shortforest forest set forest.forestquantity = (select (decode(sum(detail.quantity), null, 0, ... 阅读全文