Welcome To Snipplr
Everyone's Recent PL/SQL Snippets Tagged sql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
« Prev 1 Next »
Lets say you have a table with field called "tags" that consists from tags separated by commas and you want to check whether it includes a required tag. Here the simplest ways of doing that.
0
726
posted 10 years ago by apphp-snippets
Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.
0
868
posted 11 years ago by apphp-snippets
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
« Prev 1 Next »