PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Inititalize a value retrieved from DB to variable stored in Database

Hi,

Is it possible to assign a value in one variable to the same variable that is setup or stored as "&" variable?

For EX:

The SQLEXEC returns a year of 2022 and stores it in &YEAR.

We have the same "&YEAR" value is stored in one of custom tables

Table Structure (COUNTRY_TBL) and sample value

Country CUSTOM_VALUE

US &YEAR

Now, when we query on COUNTRY_TBL and retrieve the CUSTOM_VALUE, we have &YEAR

Is it possible to pass the 2022 value obtained in 1st SQLEXEC to above &YEAR?

So, the value in &YEAR should be assigned to the variable &YEAR stored in COUNTRY_TBL.CUSTOM_VALUE

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center