Welcome To Snipplr
Everyone's Recent PL/SQL Snippets Tagged Oracle
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
« Prev 1 Next »
This sql statement enables to detect duplicates entries over a key and creates a seq column which says which one is the sequence of the duplicates. This way you can take only the seq = 1 and still be able to identify all duplicates
0
829
posted 12 years ago by xavsio4
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
1121
posted 12 years ago by theonlyalterego
This compares selected columns between 2 tables that you think might have differences. It lists the rows and values that are different between the two sources
You can add WHERE clauses as appropriate. You could also use this to compare the resul...
0
948
posted 15 years ago by stews
« Prev 1 Next »