Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
SQL to manually upload an environment into a PeopleSoft Image and make it accessible in the Update Manager Dashboard.
insert into PS_PTIASPUSERTGTS values ('VP1', 'FS92DEV');
insert into PS_PTIASPTARGETS values ('FS92DEV', ' ', '8.53.10', '8.53', '10', 'ENG');
insert into PS_PTIASPTARGETLNG values ('FS92DEV', 'ENG');
-- REM INSERTING into PS_PTIASPLOGTGT;
Insert into PS_PTIASPLOGTGT (DBNAME,PTIASPRPTNO,PTIASPPKGAPPLYDT) values ('FS92DEV',16245533,to_timestamp('29-MAR-14','DD-MON-RR HH.MI.SSXFF AM'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment