Profile
Achievement
theonlyalterego's Recent SnippetsTagged sql
- All /
« Prev 1 Next »
This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name
0
1186
posted 12 years ago by theonlyalterego
Query to find the most recent logins for a particular user ( find 1 years worth )
0
982
posted 12 years ago by theonlyalterego
Very useful sql to find which responsibility has access to a report or request.
0
2270
posted 13 years ago by theonlyalterego
PL/SQL
Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user
I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.
0
1345
posted 13 years ago by theonlyalterego
This sql query will select the past version information about a given file from the database. An example would be searching for %ApprovalHistoryVOImpl% would return all past version numbers (in the database) for the ApprovalHistoryVOImpl.class file....
0
869
posted 15 years ago by theonlyalterego