Archive

Category Archives for "Quick Reference"

Find PeopleSoft Navigation for a component using SQL

You can use below SQL to find PeopleSoft Navigation to a component. In below SQL replace the value of PORTAL_URI_SEG2 with your component name. SELECT DISTINCT REVERSE(LTRIM(SYS_CONNECT_BY_PATH (REVERSE(PORTAL_LABEL),’ >- ‘),’ >- ‘)) “NAVIGATION” FROM PSPRSMDEFN P WHERE PORTAL_OBJNAME = ‘PORTAL_ROOT_OBJECT’ START WITH PORTAL_URI_SEG2 = ‘PRCSDEFN’ — Replace with your Component Name CONNECT BY PRIOR PORTAL_PRNTOBJNAME […]

Continue reading
1

Oracle PL/SQL Cheat Sheet

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation’s procedural language extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7) and IBM DB2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. While PL/SQL is easy to learn, it can […]

Continue reading

Perl Cheat Sheet

As a PeopleSoft admin, you will most likely need to work with Perl language. Though there isn’t a need to master Perl language, it is definitely a great language to learn. There are many commands in Perl, which you just need to keep handy and you will be able to write powerful and efficient programs. […]

Continue reading