Logo: Wesleyan University
  • Tools
    • WesPortal
    • Directory
    • Library
    • OneStop
    • WesConnect
    • Calendar
    • WesMaps
    • WFS
    • Moodle
    • EMS
    • GApps
  • About
  • Admission & Financial Aid
  • Academics
  • Campus
  • Athletics
  • Give
  • Students
  • Alumni
  • Parents

Student Faculty Information System

PeopleSoft Campus Solutions

Feed on
Posts
Comments

Expression Syntax (SQL) – Outside Sources

_person with wrench

 

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.)

Oracle Dates and Times

 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

CASE (Transact-SQL)

 From MSDN/Microsoft.com

Comments are closed.