Good point! I had never heard of the PS Query PL/SQL connection until today.
------------------------------
Enrique Pizana
PeopleSoft Developer and Support Engineer
Washington State Board for Community and Technical Colleges
------------------------------
Message from the HEUG Marketplace:------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the
HEUG Marketplace.
------------------------------
Original Message:
Sent: 01-24-2025 11:26 AM
From: Vic Goldberg
Subject: TechOnTheNet.com SQL Function Resource
Of course, this assumes that you're using Oracle as the database on the backend. It doesn't use PL/SQL if you've got Microsoft! 😊
Thanks!
Vic
---
Vic Goldberg
Retiree, Temporary Employee
University of Colorado Boulder
Independent PeopleSoft FA Consultant
Original Message:
Sent: 1/24/2025 11:20:00 AM
From: Enrique Pizana
Subject: RE: TechOnTheNet.com SQL Function Resource
I did not know PS Query uses PL/SQL. Good to know.
------------------------------
Enrique Pizana
PeopleSoft Developer and Support Engineer
Washington State Board for Community and Technical Colleges
------------------------------
Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
Original Message:
Sent: 01-24-2025 07:13 AM
From: Robert Fogarty
Subject: TechOnTheNet.com SQL Function Resource
Daniel,
Also, my "go to" ... make sure you choose Oracle/PLSQL as the database (upper left of home screen). Whether using TechOnTheNet or just an internet search, it is important to know that PS Query uses PLSQL.
Thank you,
Bob
------------------------------
Robert Fogarty PMP
Reporting Team Lead | LionPATH Development and Maintenance Office
The Pennsylvania State University
------------------------------
Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
Original Message:
Sent: 01-23-2025 08:10 PM
From: Daniel Labrecque
Subject: TechOnTheNet.com SQL Function Resource
TechOnTheNet has been invaluable in helping me write better SQL expressions for PSQuery and direct SQL. Its well-organized layout makes finding functions and commands quick and easy, more so than any other site I've used. In fact, I am working on a document to share with the community on all the SQL functions that work in PSQuery Expressions (there are a lot).
The practical examples are straightforward and adaptable to PeopleSoft environments, helping me troubleshoot issues and write efficient queries. The detailed breakdowns of SQL functions have also given me a better understanding of how to use them effectively.
If you're looking for a reliable, user-friendly resource to improve your SQL skills, I highly recommend TechOnTheNet.
------------------------------
Daniel Labrecque
Senior 2 Business Systems Analyst/Functional Architect
University of Nevada, Las Vegas
------------------------------
Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------