Is this valid in Oracle?

  • Is the following query legal in Oracle?

    SELECT SUM(MAX(POINTS)) FROM PS_HRS_JO_SCR_CMPP

    WHERE HRS_JO_SCR_SUMM_ID = ' ' AND HRS_JO_SCR_SEQ = 0 GROUP BY COMPETENCY

    It was found in a process in our PeopleSoft system, and appears to have been there for quite a while. Only thing our PeopleSoft team can think of is that the code where this query lives as never been run in our environment.

  • Yes. Syntax is sound.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • PaulB-TheOneAndOnly (4/15/2010)


    Yes. Syntax is sound.

    Thank you, Paul.

    I need to apologize for not posting back earlier. Yes, it is, and it is a problem for organizations running PeopleSoft on MS SQL Server. Oracle is issuing a fix for SQL Server. Before Oracle bought PeopleSoft this was not an issue as PeopleSoft developed against SQL Server.

    I guess I sould look into learning about Oracle. Do they have a free version of their engine that one can use to learn some basics?

  • Lynn Pettis (4/15/2010)


    I guess I sould look into learning about Oracle. Do they have a free version of their engine that one can use to learn some basics?

    Yes. Oracle software for "educational" purposes is free, you do not have to pay a license. I would probably start with Ora10g Express Edition, you can download it here... http://www.oracle.com/technology/software/products/database/xe/index.html

    A good forum for Oracle stuff can be found here... http://www.dbasupport.com/forums/forumdisplay.php?f=20

    The best part of it is that Oracle documentation is public and for free, here is the whole library for Ora10g... http://www.oracle.com/pls/db102/portal.all_books

    I'm sure you will enjoy the experience, aint nothing wrong about becoming bi-lingual 😉

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply