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






GoDevil

 
 

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

08 2008 档案

 
oracle 使用leading, use_nl, rownum调优
摘要：1、使用leading和use_nl来设置表的查询顺序，来加快查询速度，一般把小表设为第一个表。 /*+LEADING(TABLE)*/ 将指定的表作为连接次序中的首表. /*+USE_NL(TABLE)*/ 将指定表与嵌套的连接的行源进行连接,并把指定表作为内部表. 成本计算方法： 设小表100行，大表100000行。 两表均有索引： 如果小表在内，大表在外(驱动表)的话，则扫描次数为... 阅读全文
posted @ 2008-08-29 14:03 Kevin's Blogy 阅读(6442) 评论(0) 推荐(1)
Troubleshoot the SMTP Server
摘要：The SendMail function in PeopleSoft uses the SMTP server to send emails. The first thing to do when troubleshooting problems with emails not being sent is to make sure your SMTP server is up and runni... 阅读全文
posted @ 2008-08-28 14:02 Kevin's Blogy 阅读(269) 评论(0) 推荐(0)
Application Engine ReUse Statement in PeopleSoft
摘要：The ReUse in Application Engine was brought to my attention by a great blog that I follow regularly. The original post can be found at http://peoplesofttipster.com/2007/07/31/reuse-in-app-engines/. ... 阅读全文
posted @ 2008-08-26 14:21 Kevin's Blogy 阅读(275) 评论(0) 推荐(0)
Delete Multiple Files Using PeopleCode
摘要：Deleting files sitting on a server using PeopleCode is one thing I'm sure you will be doing sometime during your PeopleSoft career. The code below should help you out and get you started! /*The path ... 阅读全文
posted @ 2008-08-21 16:20 Kevin's Blogy 阅读(416) 评论(0) 推荐(0)
PeopleCode SearchSave Event
摘要：SearchSave PeopleCode is performed after the user clicks the Search button or the Add button on the search page. User SearchSave to validate values entered in the search page fields. Place S... 阅读全文
posted @ 2008-08-19 10:37 Kevin's Blogy 阅读(333) 评论(0) 推荐(0)
Hide a Grid Column From a Grid in PeopleCode
摘要：This code should be helpful if you are trying to hide a grid column using PeopleCode To hide a column in a grid (using the Grid and GridColumn objects). You no longer must loop through every row in t... 阅读全文
posted @ 2008-08-18 16:40 Kevin's Blogy 阅读(630) 评论(0) 推荐(0)
Delete Grid Blank Rows Entered by Users When Saving
摘要：Sometimes users click the "+" on the grid to enter data but end up clicking it more than once and getting some extra empty rows in the gird. The peopleCode to get rid of any extra empty grid rows when... 阅读全文
posted @ 2008-08-18 15:46 Kevin's Blogy 阅读(361) 评论(0) 推荐(0)
Calling an Application Engine from PeopleCode
摘要：The PeopleCode below will show you how to call an Application Engine from PeopleCode. Some refer to this as “Real-Time Application Engine Processing.” For example, when a user save’s a page, you may w... 阅读全文
posted @ 2008-08-13 11:27 Kevin's Blogy 阅读(302) 评论(0) 推荐(0)
Run an SQR From a PeopleSoft Application Engine
摘要：Here is a good sample of how to launch an SQR from within PeopleCode. You can use the peoplecode function called “ScheduleProcess”. Here is the example: &PROCESS_NAME = "SQRNAME"; &PROCESS_TYPE = "SQ... 阅读全文
posted @ 2008-08-12 09:57 Kevin's Blogy 阅读(412) 评论(0) 推荐(0)
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 阅读(258) 评论(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 阅读(686) 评论(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 阅读(1000) 评论(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 阅读(1004) 评论(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 阅读(219) 评论(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 阅读(241) 评论(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 阅读(266) 评论(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 阅读(275) 评论(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 阅读(317) 评论(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 阅读(392) 评论(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 阅读(432) 评论(0) 推荐(0)
Manipulating Data on a Grid: Scroll PeopleCode
摘要：When you have a grid that is filled with data; data that you don't want. How do you clear it out and then fill it with the data set that you do want? Well, here are the simple steps to do just that. ... 阅读全文
posted @ 2008-08-08 17:21 Kevin's Blogy 阅读(439) 评论(0) 推荐(0)
Read a File Using File Layout and insert data into a record
摘要：Local File &MYFILE; Local Record &REC; Local array of string &ARRAY; Local string &FILE_DIRECTORY, &FileName; &FileName = "MY_FILE_NAME.txt"; &FILE_DIRTORY = "/MYDIRECTORY/" /*open file for reading*/... 阅读全文
posted @ 2008-08-08 17:05 Kevin's Blogy 阅读(377) 评论(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-08 16:41 Kevin's Blogy 阅读(230) 评论(0) 推荐(0)
START WITH and CONNECT BY in Oracle
摘要：start with .. connect by clause can be used to select data that has a hierarchical relationship. Usually, it is some sort of parent child relationship like supervisor and an employee. Let’s assume we ... 阅读全文
posted @ 2008-08-08 16:13 Kevin's Blogy 阅读(323) 评论(0) 推荐(0)
Compare Data from the Same Table in two Different Environments
摘要：The Oracle SQL below compares table1 that has 2 key fields and 3 regular fields. Note: For the SQL below to work, your password needs to be the same in both environments. If not, then a connection usi... 阅读全文
posted @ 2008-08-08 15:30 Kevin's Blogy 阅读(309) 评论(0) 推荐(0)
Vendor Pending Transactions
摘要：A quick function that will allow you to verify if a specific vendor has any pending transaction(s). Function vendor_pnding_transactions(); &VENDOR = VENDOR_ID; SQLExec("select 'X' from ps... 阅读全文
posted @ 2008-08-08 15:24 Kevin's Blogy 阅读(254) 评论(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-08 15:21 Kevin's Blogy 阅读(265) 评论(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-08 15:19 Kevin's Blogy 阅读(470) 评论(0) 推荐(0)
PeopleSoft Financials Tables
摘要：General Ledger Tables PS_LEDGER: The general ledger data table. PS_JRNL_HEADER: Stores general ledger journal header data. PS_JRNL_LN: Stores general ledger journal line data. ps_combo_rule_tbl: Store... 阅读全文
posted @ 2008-08-08 14:58 Kevin's Blogy 阅读(484) 评论(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-08 14:55 Kevin's Blogy 阅读(229) 评论(0) 推荐(0)
PeopleSoft Object Types Definitions
摘要：PeopleSoft stores object definitions types such as Record, Field and SQL definitions as numbers in PeopleTools meta-tables. Here is a list of what each number means with respect to its definition. Def... 阅读全文
posted @ 2008-08-08 14:39 Kevin's Blogy 阅读(303) 评论(0) 推荐(0)
Convert From One Currency to Another
摘要：The function is ConvertCurrency to convert currency from US dollar to any other currency on the PS_RT_RATE_TBL . ConvertCurrency(amt, currency_cd, exchng_to_currency, exchng_rt_type, effdt, converted... 阅读全文
posted @ 2008-08-08 14:26 Kevin's Blogy 阅读(339) 评论(0) 推荐(0)
Unlock PeopleSoft Objects All at Once
摘要： 阅读全文
posted @ 2008-08-08 11:25 Kevin's Blogy 阅读(209) 评论(0) 推荐(0)
Component Permission List Query
摘要：An SQL that will identify permission lists along with permission lists description assigned to a specific component. SELECT menu.menuname, compdfn.pnlgrpname, auth.classid permission_list, ... 阅读全文
posted @ 2008-08-07 12:41 Kevin's Blogy 阅读(236) 评论(0) 推荐(0)
Get Table Sizes in your Schema
摘要：If you want to see how much space your tables are taking in the database, log in to the shcema and execute this SQL. SELECT segment_name table_name, MAX (tablespace_name) tablespace_name, S... 阅读全文
posted @ 2008-08-07 12:34 Kevin's Blogy 阅读(240) 评论(0) 推荐(0)
Create a Database Link
摘要：In many cases you might need to compare data between tables across different databases. For example your test instance and production instance. You can easily create a database link between the 2 i... 阅读全文
posted @ 2008-08-07 12:33 Kevin's Blogy 阅读(350) 评论(0) 推荐(0)
Oracle Minus Operator
摘要：I find the MINUS operator very handy and use it a lot to compare tables and find out missing things. For example suppose you want to compare Table1 with Table2. If the two tables have the same layou... 阅读全文
posted @ 2008-08-07 12:30 Kevin's Blogy 阅读(284) 评论(0) 推荐(0)
Call Unix Script from PeopleCode
摘要：A function to call UNIX and/or shell script from PeopleCode. /*call unix script from PeopleCode*/ Function CallScript; /*According to PeopleBooks, PS_HOME is always prefixed to the file location... 阅读全文
posted @ 2008-08-07 12:29 Kevin's Blogy 阅读(391) 评论(0) 推荐(0)
Dynamic Drop Down(Translate Values)
摘要：This code i have got Ittool box.com. It is very usefull. we usually have requirement when we want to hide some translate values from translate field on page for some business reason. In this case we c... 阅读全文
posted @ 2008-08-07 12:25 Kevin's Blogy 阅读(325) 评论(0) 推荐(0)