摘要:
a method of transposing the rows into columns and to show the correct value 阅读全文
摘要:
Datatypes translation between Oracle and SQL Server 阅读全文
摘要:
这里用到了Oracle的一个树形结构查询函数select * from record START WITH A.TREE_NODE IN ('COST_CTR_10053')CONNECT BY PRIOR A.TREE_NODE_NUM = A.PARENT_NODE_NUM.查出指定节点下的所以 阅读全文
摘要:
Understanding SQR Data Elements !Variables!Variables are storage places for text or numbers that you define and manipulate.!• $ begins a text or date 阅读全文
摘要:
PeopleSoft Home Subdirectoriesappserv — home to the Application Server and Process Scheduler Server; location of psadmin where you start, stop, and ma... 阅读全文
摘要:
People Tools catalog tables.ProjectsPSPROJECTDEFN — Project header tablePSPROJECTITEM — Definitions in the projectFieldsPSDBFIELD — Fields in the syst... 阅读全文
摘要:
over(),包含三个分析子句:分组(partition by), 排序(order by), 窗口(rows) ,他们的使用形式如下:over(partition by xxx order by yyy rows between zzz)。 阅读全文
摘要:
start with和connect by CONNECT_BY_ROOT 阅读全文
摘要:
Ajax 的核心对象为XMLHttpRequest现在大部分主流浏览器都支持Ajax技术 阅读全文
摘要:
peoplesoft 阅读全文