PeopleSoft Query Tips and Tricks
From The University of Akron Support Wiki
Contents
Oracle Nuances
Oracle dates in the field list
PSQuery Limitations
Maximum of 26 records
PSQuery can have a maximum of 26 records in a query. This limitation is a result of how aliases are assigned to the recrods, namely via the alphabet [A-Z], and there is no handling for what happens after the "Zth" table is added. It does not assign an alias and the query breaks.
Other PSQuery Tips
Adding Oracle Hints to PSQueries
I haven't tried it yet, but here is a step-by-step on adding an Oracle hint to a PSQuery