摘要:
What I would like to accomplish is every time the user adds a new email address i would want to check for the following:1. Check for blank email type2. Edit to check for '@' character3. Check if email... 阅读全文
摘要:
We can use the connect by prior function provided by Oracle to traverse the Dept security Tree . Suppose an Organization has 7 levels in Dept tree i.e. 1 to 7 .We want to traverse the dept tree from l... 阅读全文
摘要:
An SQL to help gathering storage tablespace statistics. The SQL will list all tablespace names in a particular database along with available, used and percent used storage space in MB.SELECT a.tables... 阅读全文
摘要:
1. Pages that could be accessed by a specific permission list.SELECT b.menuname, b.barname, b.baritemname, b.pnlitemname AS pagename, c.pageaccessdescr, DECODE (b.displayonly, 0, 'No', 1, 'Yes') AS di... 阅读全文
摘要:
A function to facilitate the addition of a leading character to a field value. The function takes three parameters:- &LEADCHAR: The character you want to append to your value.- &FIELDZISE: The... 阅读全文
摘要:
A query that will take a PeopleSoft role name as an input and returns all pages that could be access by that role. The query will also indicate what kind of operations a user can perform on that page.... 阅读全文
摘要:
how to dynamically assign a prompt table depending on a drop down value (see image below)The table behind the grid is PORTAL_SECDYVW and as you can see from the image below, the PORTAL_AUTHNAME field ... 阅读全文
摘要:
This article explains how to create XML Publisher also called BI Publisher reports in PeopleSoft. XML Publisher is the only Reporting platform in the Fusion Application. Before we talk about how to cr... 阅读全文
摘要:
To create popupmenu.Create new menu as follows.Select popup opion.-Click on define transfer.Assign any menu, component, page (comp item), click the check box at bottom.Click ok then save the menu.Then... 阅读全文
摘要:
Open Configuration Manager -> Profile ->Create.• Select Connection Type as Application Server.• Enter Application Server Name• Machine Name or IP Address should be your machine... 阅读全文