sqlplus query to capture *unchanged and *changed rows only from PSPROJECTITEM
Hello,
After PeopleSoft project compares the project compare report source and target status gets stored in PSPROJECTITEM table.
During upgrade , we have situation where we are not performing project compare through app designer and re-suing existing definition to import project.
Now we have to tally the number object from ready to get copy to target and to identify number of custom objects. In order to do that I wanted to extract rows from PSPROJECTITEM table for column targetstatus has *unchanged and *changed values. I attempted to use regular expression function but it does not helping much. What is query to extract these rows?