Friday, January 15, 2016

Retrieve passwords with update statement and execute the update statements in other PeopleSoft environment.

Select 'update syshcm.psoprdefn set operpswd='''||operpswd ||''' where oprid='''||oprid||''';' from syshcm.psoprdefn where oprid in ( );

 
Select oprid, operpswd from syshcm.psoprdefn where oprid in ( );

No comments:

Post a Comment