theonlyalterego


Member since 08/11/2008

8 snippets

2566 profile views

1 Comment(s) Posted

View their favorites

Profile

Achievement

first submission:submitting first snipplet

theonlyalterego's Recent SnippetsTagged sql



« Prev 1 Next »
find what profile values are set for a particular user
0 603 posted 11 years ago by theonlyalterego
This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name
0 911 posted 12 years ago by theonlyalterego
Query to find the most recent logins for a particular user ( find 1 years worth )
0 783 posted 12 years ago by theonlyalterego
A slight adaptation on the sql in the Oracle Forum
0 823 posted 12 years ago by theonlyalterego
Very useful sql to find which responsibility has access to a report or request.
0 1805 posted 12 years ago by theonlyalterego
I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.
0 1121 posted 12 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 649 posted 14 years ago by theonlyalterego
« Prev 1 Next »