Database

The term alter audit in PeopleSoft refers to running an alter build script in application designe...

You can use the ANALYZE TABLE command to store table statistics for Oracle (and many other DBMS) ...

To add a new sequence number based on existing key structures where the sequence number increment...

The following SQL is for an Oracle Database and it attempts to approximate the size of a PeopleSo...

If you are creating an audit record, there are normally three fields that need to go at the start...

You may get the following Oracle error when building a component with multiple scroll levels: OR...

The following SQL will automatically generate a formatted select statement with all the fields of...

There are a number of ID fields in PeopleSoft that are auto-numbered. A good example is the EMPLI...

Sometimes, clicking the hyperlink in a pagelet to another component, takes you to the component b...

Use the following code to alter your session's current schema: ALTER SESSION SET current_schema ...

The following SQL can be used to generate a script to create public synonyms (in Oracle). This ex...

If you ever get the following message: SQL Access Manager SQL error. Stmt #: 2 Error Position: ...

When trying to sort based on values that do not fit the standard ascending and descending sort lo...

Sometimes you'll need to known when an environment was last refreshed and may not have the detail...

The Case-When-Exists expression in Oracle is really handy. Here's an example of how to use it in ...

The following SQL is an example of how to enumerate (number) rows in SQL. This SQL will only work...

If you ever want to conditionally count the number of times a particular condition occurs in SQL,...

While performing an alter on a table, I received the following error in the SQL Build log (PSBUIL...

Partition By is a construct in Oracle that groups data in a select clause rather than by using gr...

In PeopleSoft the DATE_END field is defined as a date field. If the date 12/31/2009 is selected f...

If you are logged into the system with enough rights (e.g. SYSADM) you can kill database sessions...

A database link (dblink) links databases. It allows you to query against other databases using th...

On Oracle databases, you can't use standard SQL insert statements on fields that have a type of L...

After completing an PeopleSoft installation, I found that I had missed a step as there were no ta...

Unique constraint errors are a part of life as a PeopleSoft developer. The most common way to tro...

While attempting to start the application server on an Oracle database, the following error messa...

After upgrading to PeopleTools 8.51, the sign on page started displaying the following message: ...

Here are some general guidelines around how to write a data conversion script: Truncate targe...

When testing, a common requirement is to select from a list of random Users (OPRID) or IDs (EMPLI...

The Oracle client is required on your PC if you want to connect to the PeopleSoft database in two...

You can use the following SQL in Oracle to identify the top 100 tables that may be good candidate...

If you return either a true or false string as the result of executing SQL through PeopleCode, it...

There's a view of all the data dictionary views in oracle called DICTIONARY. So you can query it ...

Oracle dynamic performance views (v$) are built on the virtual tables ($x). The views (v$) are mu...

If you've ever worked on Oracle databases then you've probably heard of, and stay well away from ...

The following SQL is an example of looping through user data and presenting it as a comma separat...

A no matching buffer error occurs when there is a mismatch in the data within the component buffe...

The following queries give you the structure of a component. This query gives you the pages, occ...

For security and consistency you should wrap code that is environment specific around logic that...

The following PL/SQL is my attempt to search the message catalog for a particular piece of text s...

The SQL below will return the structure of your message if it is rowset based (uses PeopleSoft re...

Suppose you have the following text in your editor: select FIELD1, FIELD2, FIELD3 from TABLE1; ...

PeopleTools tables are the tables in your PeopleSoft environment that store PeopleTools meta-data...

PeopleSoft has thousands of views! If you want to know just how many there are, try this query to...