I had the need to count an occurrence of a specific character in a string and after tossing some ideas back and forth between a couple of my colleges, we came up with the below two SQLs. You pass a string and identify the character you are looking to count its occurrence. In both SQLs below, I'm trying to count how many times does ">>" exists in string "This is>>a string>>to look into>>". The answer of course is 3 times.
SQL Option 1:
A query that will take a PeopleSoft role name as an input and returns all pages that could be access by that role. The query will also indicate what kind of operations a user can perform on that page. Example, Add Update/Display and so forth.
A query that takes a PeopleSoft role name as a value and returns Permission List(s) associated to that role.
A section to collect and organize PeopleSoft Role related queries.
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Recent comments
2 years 22 weeks ago
2 years 27 weeks ago
2 years 27 weeks ago
2 years 29 weeks ago
2 years 30 weeks ago
2 years 30 weeks ago
2 years 32 weeks ago
2 years 33 weeks ago
2 years 36 weeks ago
2 years 42 weeks ago