Query Expression Syntax (SQL) – Outside Sources
There are a number of outside sources that have useful information that you can apply when working with PeopleSoft Query. Many include examples of syntax that can be used in Expressions in Query. Some can serve as a starting point for researching related topics. The following are pdfs or links to these sources.
For more detailed information on this topic, click on this link to the Query – Expressions page.
EXTERNAL LINKS RELATED TO SYNTAX
Query – key_functions_in_oracle_sql Harvard
A listing of five types of Functions used at Harvard: Grouping, Numeric, String, Date, and Conversion
Oracle Database Search Results: DATE within SQL Reference
Result of a search for “DATE” in the Oracle Database Documentation Library. (Use the Search box for other Expression related information, e.g. char, round, comparison, etc.)
This is a page from Stanford University’s Infolab and discusses DATE Format, the Current Time and Operations on DATE
Oracle/PLSQL Topics: Built-In Functions
From Tech on the Net
From MSDN/Microsoft.com