Login / Register


Share Snipplr


Welcome To Snipplr


Everyone's Recent PL/SQL Snippets



« Prev 1 Next »
  1. FAV

    Search in Tags Set in MySQL

    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.
    PL/SQL 10 views posted 6 years ago by apphp-snippets
  2. FAV

    Find token into list of values

    Find a key from a list of values​​. parameters: sbValues​​: List of Values 'A;B;C;D' sbToken: Key 'B' sbSeparator: ',' or any defined sbValues Example: select FSBFINDTOKEN('A;B;C;D','B',';') from DUAL; ------------------- Y
    PL/SQL 13 views posted 6 years ago by ceduard0
  3. FAV

    Selecting a Random Row from Table in MySQL

    Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.
    PL/SQL 8 views posted 6 years ago by apphp-snippets
  4. FAV

    Retornar Cursor Oracle para Java

    Procedimiento para retornar un Cursor y recorrerlo en Java
    PL/SQL 30 views posted 7 years ago by thescorpion
  5. FAV

    Mover de TableSpace un Objeto o tabla

    comando para cambiar el tablespace de un objeto
    PL/SQL 15 views posted 7 years ago by thescorpion
  6. FAV

    Strategy to identify duplicates in an ETL context (for example)

    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
    PL/SQL 9 views posted 8 years ago by xavsio4
  7. FAV

    working with XML (find out if element or attribute exists)

    PL/SQL 14 views posted 8 years ago by avj
  8. FAV

    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.
    PL/SQL 24 views posted 8 years ago by theonlyalterego
  9. FAV

    Oracle - Iterating Cursor

    this code is for iterating through a cursor
    PL/SQL 5 views posted 8 years ago by Hisoka
  10. FAV

    phpmyadmin exportl filename template

    PL/SQL 5 views posted 9 years ago by lordvithis
  11. FAV

    Update da table a table

    PL/SQL 7 views posted 9 years ago by tuffo19
  12. FAV

    Hold concurrent requests by name

    PL/SQL 9 views posted 10 years ago by kitzelh
  13. FAV

    Kill all sessions from host in Oracle

    PL/SQL 9 views posted 10 years ago by kamilch
  14. FAV

    Create new Oracle user

    PL/SQL 8 views posted 10 years ago by kamilch
  15. FAV

    Oracle TO_DATE function

    PL/SQL 11 views posted 10 years ago by kamilch
  16. FAV

    Kill oracle session

    PL/SQL 5 views posted 10 years ago by kamilch
  17. FAV

    Drop sequences in current schema

    PL/SQL 5 views posted 10 years ago by kamilch
  18. FAV

    Drop all tables in Oracle

    PL/SQL saved by 1 person 14 views posted 10 years ago by kamilch
  19. FAV

    Kill locked session

    PL/SQL 7 views posted 10 years ago by tenkyu
  20. FAV

    Trim TAB/CR/LF/Space from string

    PL/SQL saved by 1 person 7 views posted 11 years ago by jamarama
  21. FAV

    Function to get first record from query and return single value

    Nothing amazing here, just an efficient way to get the first row. Be sure to set your ORDER BY clause properly.
    PL/SQL 10 views posted 11 years ago by stews
  22. FAV

    Record Exists function template

    I often need to know if a record exists in a table. This method is probably the most efficient. Too many people don't use the exceptions that Oracle provides, which is a shame. I think I got it from Tom Kyte's site? Or Steven Feuerstein?
    PL/SQL 9 views posted 11 years ago by stews
  23. FAV

    Efficiently compare columns from two tables

    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...
    PL/SQL 7 views posted 11 years ago by stews
  24. FAV

    UPDATE using WHERE CURRENT OF clause

    I can never remember the syntax on the "FOR UPDATE OF" clause!
    PL/SQL 8 views posted 11 years ago by stews
« Prev 1 Next »