Login / Register


Share Snipplr


Welcome To Snipplr


Everyone's Recent PL/SQL Snippets Tagged sql



« 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 866 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
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
0 702 posted 13 years ago by tuffo19
« Prev 1 Next »