April 6, 2010 at 2:01 pm
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.
April 15, 2010 at 8:28 am
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.April 15, 2010 at 9:27 am
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?
April 16, 2010 at 7:39 am
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