A straight forward SQL to get edit tables behind field(s) for a specific record. The SQL execludes any edit tables that start with "%" as those are dynamic edit tables with values populated by PeopleCode at run time and thus will not be of a good use in this query.
SELECT R.FIELDNAME , R.EDITTABLE FROM PSRECFIELDDB R , PSDBFIELD F WHERE R.RECNAME = :RecordName AND SUBSTR(R.EDITTABLE,1,1) <> '%' AND R.EDITTABLE <> ' ' AND R.FIELDNAME = F.FIELDNAME AND F.FLDNOTUSED = 0;
A section to collect and organize PeopleSoft permission lists related queries.
A query to list all user IDs that are assigned to a specific permission list.
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.
A Very simple SQL to return Oracle's database version you are currently in.
As of Oracle 10g, the SUBSTR has been enhanced to support searches for regular expressions. The new function is named REGEXP_SUBSTR. You can use the new function to perform advanced searches against a string.
Syntax:
| Title | Under | Posted on |
|---|---|---|
| How to run nvision report through portal | PeopleSoft Technical | 08/31/2010 - 4:45am |
| Any1 here who can help? | PeopleSoft Technical | 08/31/2010 - 2:12am |
| How to create matrix layout | PeopleSoft Technical | 08/27/2010 - 2:22am |
| UnCaught C++ Exception | PeopleSoft Technical | 08/10/2010 - 9:05am |
Recent comments
1 day 1 hour ago
1 day 3 hours ago
1 day 3 hours ago
2 days 6 hours ago
2 days 7 hours ago
2 days 11 hours ago
3 days 53 min ago
1 week 3 hours ago
1 week 3 hours ago
1 week 3 hours ago