PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

DB2 to Oracle database change - what SQL, PeopleCode changes need to be made

in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered

We are changing our platform for PeopleSoft application from DB2 to Oracle and I would like to find out what needs to change for example:


CURRENT DATE in DB2 now needs to change to SYSDATE in Oracle.

same when we subtract or add to the SYSDATE in DB2 we write as

"CURRENT DATE + 2 Days" in Oracle is "SYSDATE + 2"

If someone has a list I would really like to see this list of functions and other items that need to change.


regards

SOBEK

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT PeopleTools Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center