• 博客园logo
  • 会员
  • 众包
  • 新闻
  • 博问
  • 闪存
  • 赞助商
  • HarmonyOS
  • Chat2DB
    • 搜索
      所有博客
    • 搜索
      当前博客
  • 写随笔 我的博客 短消息 简洁模式
    用户头像
    我的博客 我的园子 账号设置 会员中心 简洁模式 ... 退出登录
    注册 登录
 






GoDevil

 
 

Powered by 博客园
博客园 | 首页 | 新随笔 | 联系 | 订阅 订阅 | 管理

2008年8月11日

Find Navigation of Page from Component Name
摘要: Many times we came across situation where we have Page name but we dont know the navigation for this page in Portal. Following SQL makes the job easy for us. Execute the following SQL in Database. SE... 阅读全文
posted @ 2008-08-11 17:03 Kevin's Blogy 阅读(256) 评论(0) 推荐(0)
 
Oracle Group By Grouping Sets
摘要: So, what if you are only interested in totals. Well, Oracle does provide an extension to the GROUP BY clause called GROUPING SETS that you can use to generate summary information at the level you choo... 阅读全文
posted @ 2008-08-11 16:28 Kevin's Blogy 阅读(684) 评论(0) 推荐(0)
 
Oracle Group By ROLLUP-SubTotal
摘要: At normal time, you may want to have the subtotal for each region over all months, along with the total for all regions, or you may want the subtotal for each month over all regions, along with the to... 阅读全文
posted @ 2008-08-11 16:23 Kevin's Blogy 阅读(997) 评论(0) 推荐(0)
 
PeopleSoft PeopleTools Meta-Tables
摘要: This is an attempt to list PeopleSoft meta-tables along with some kind of description for every table. The list will be broken into categories (pages, records, components, and so forth). Please feel f... 阅读全文
posted @ 2008-08-11 15:59 Kevin's Blogy 阅读(994) 评论(0) 推荐(0)
 
Security Tables
摘要: PSOPRDEFN - UserIds created. PSCLASSDEFN - Permission List definition. PSROLEDEFN - Role Definition table PSAUTHITEM - Menus, Components and Pages attached to a permission list. PSROLEUSER - Contains ... 阅读全文
posted @ 2008-08-11 15:57 Kevin's Blogy 阅读(217) 评论(0) 推荐(0)
 
Unlock PeopleSoft Objects All at Once
摘要: Change control is used in Application Designer to lock definitions and track history changes for each object. Change control can be activated through Application Designer using Tools > Change Control ... 阅读全文
posted @ 2008-08-11 15:26 Kevin's Blogy 阅读(237) 评论(0) 推荐(0)
 
Migration: Find Duplicate Objects in Application Desinger Projects
摘要: The sql will identify duplicate objects in different application designer projects to eliminate duplicate work by developers. You will find the SQL very handy during the analysis phase of a peoplesoft... 阅读全文
posted @ 2008-08-11 15:21 Kevin's Blogy 阅读(262) 评论(0) 推荐(0)
 
Trace Application Engine Processes Using Process Definitions
摘要: In this post I will show you how to trace an application engine process using the Process Definitions without setting the trace in the Process Scheduler’s psprcs.cfg configuration file. Navigate to th... 阅读全文
posted @ 2008-08-11 15:18 Kevin's Blogy 阅读(273) 评论(0) 推荐(0)
 
Dynamic View and Drop Down Menu
摘要: This was kind of interesting to figure out. What I was going after is the following. I had a drop down box on a page that shows some Business Units. The values however need to be dynamic and change de... 阅读全文
posted @ 2008-08-11 15:13 Kevin's Blogy 阅读(313) 评论(0) 推荐(0)
 
Decode()函数使用技巧
摘要: decode(条件,值1,翻译值1,值2,翻译值2,...值n,翻译值n,缺省值)该函数的含义如下:IF 条件=值1 THEN    RETURN(翻译值1)ELSIF 条件=值2 THEN    RETURN(翻译值2)    ......ELSIF 条件=值n THEN    RETURN(翻译值n)ELSE    RETURN(缺省值)END IF· 使用方法:1、比较大小sele... 阅读全文
posted @ 2008-08-11 13:50 Kevin's Blogy 阅读(390) 评论(0) 推荐(0)
 
Check Box Select/Deselect All on Grid
摘要: The below function is to be used on a grid with multiple check boxes. Place the code behind a FieldChange event and users will have the option to Select or Deselect grid rows all at once. Fucntion s... 阅读全文
posted @ 2008-08-11 09:23 Kevin's Blogy 阅读(430) 评论(0) 推荐(0)