![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
jl19880317
这个作者很懒,什么都没留下…
展开
-
PS_PTLT_COMP_NAV
PS_PTLT_COMP_NAV – Define Components Navigation Setup record (in PT>=8.4xx). It is a very useful table especially when you are given a certain PeopleSoft link or Component and you don’t know how to id转载 2012-11-20 08:34:26 · 378 阅读 · 0 评论 -
How to read a SQL Trace in PeopleSoft
How to read a SQL Trace in PeopleSoftAs always with so many things, I struggled initially to understand the trace file. More often, I would generate a trace file and did not understand every aspec转载 2013-05-14 11:15:40 · 1020 阅读 · 0 评论 -
Oracle SQL常用函数
新增:查询位置SQL :SELECT INSTR(DESCR,'.') FROM PS_DEPT_TBL 1. ASCII 返回与指定的字符对应的十进制数; SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual; A A ZERO SPACE --------- ----转载 2013-04-14 23:56:11 · 2390 阅读 · 0 评论 -
Oracle PL/SQL之内联接、外联接、交叉连接
oracle的联接分如下几种:内联接(inner join)。外联接(outer join):全联接(full join)、左联接(left join)、右联接(right join)。交叉联接(cross join)。外联接与内联接不一样,外连接返回到查询结果中的不仅包含符合条件的行,还包括左表(左外连接),右表(右外连接)或者两个连接表(全外连接)中的所有不符合条件的数据行转载 2012-12-03 10:49:01 · 763 阅读 · 1 评论 -
Process Scheduler monitoring useful script
SELECT S.SERVERNAME, X.XLATSHORTNAME, X.FIELDVALUE, cast(S.MAXCPU as varchar2(3)) || '%' MAXCPU, cast(S.PRCSDISKSPACE as varchar2(15)) || 'MB' PRCS_DISK_SPACE,转载 2012-11-20 09:44:31 · 282 阅读 · 0 评论 -
Get process's navigation path by using process name
SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label),' > ')) ,' > ') PATH FROM PSPRSMDEFN WHERE PORTAL_NAME ='EMPLOYEE' AND PORTAL_PRNTOBJNAME = 'PORTAL_R转载 2012-11-20 09:55:08 · 393 阅读 · 0 评论 -
Check if user has access to CI
SELECT C.ROLEUSER ,B.ROLENAME ,A.CLASSID, -- OPRID A.BCNAME -- CI , A.BCMETHOD FROM PSAUTHBUSCOMP A, PSROLECLASS B, PSROLEUSER C WHERE C.ROLENAME = B.RO转载 2012-11-20 09:52:48 · 395 阅读 · 0 评论 -
获取Process、Component 和 Page 的导航路径
Navigation based off ProcessSELECT PRCSPNL.PRCSNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"FROM PSMENUITEM MENU, PS_PRCSDEFNPNL PRCSPNL, PSMENUDEFN MNUDF转载 2012-11-20 09:48:28 · 496 阅读 · 0 评论 -
Migrating Queries from One User To Another从一个用户迁移到另一个查询
If you ever have a need to migrate queries from one user to another, you can do it quickly and easily with this useful SQL script. If you want to make the Query Public, simply change the NEWPSUSERID转载 2012-11-20 09:45:56 · 296 阅读 · 0 评论 -
search for queries utilizing a specific field
The "Find Object References - Record Field" feature in Application Designer, when used to search for queries utilizing a specific field (i.e. "EMPL_STATUS"), is not accurate because it returns que转载 2012-11-20 09:36:29 · 333 阅读 · 0 评论