Welcome To Snipplr


Everyone's Recent SQL Snippets



« Prev 1 2 3 4 5 ... 18
  1. FAV

    SQL queries to change http to https in WordPress posts/pages

    More info: https://www.catswhocode.com/blog/install-https-wordpress
    SQL 16 views posted 2 years ago by catswhocode
  2. FAV

    Primary Key and Foreign Key

    A few examples of creating a primary key and a foreign key
    SQL 14 views posted 2 years ago by bbrumm
  3. FAV

    Insert or Update Record if Unique Key Already Exists

    This snippet allows you to insert new record into table. In case a unique key already exists - it updates appropriate fields only, leaving other fields untouched.
    SQL 18 views posted 2 years ago by apphp-snippets
  4. FAV

    Oracle COS Function

    A few examples of the COS function.
    SQL 18 views posted 2 years ago by bbrumm
  5. FAV

    Oracle VARIANCE Function

    A few examples of the VARIANCE function.
    SQL 15 views posted 2 years ago by bbrumm
  6. FAV

    SQL To get the Server Timezone.

    The below code has 2 snippets. to find the time difference from the current zone and the other is to find the timezone of the server
    SQL 16 views posted 2 years ago by sankarwaits
  7. FAV

    Sending Mail in MS SQL

    Following steps to be completed to configure an email account and send email from SQL Server
    SQL 16 views posted 2 years ago by sankarwaits
  8. FAV

    Oracle CORR Function

    A few examples of the CORR function.
    SQL 13 views posted 2 years ago by bbrumm
  9. FAV

    Oracle DBTIMEZONE Function

    An example of the DBTIMEZONE function.
    SQL 12 views posted 2 years ago by bbrumm
  10. FAV

    Oracle BFILENAME Function

    A few examples of the BFILENAME function.
    SQL 16 views posted 2 years ago by bbrumm
  11. FAV

    Oracle SESSIONTIMEZONE Function

    A few examples of the SESSIONTIMEZONE function.
    SQL 9 views posted 2 years ago by bbrumm
  12. FAV

    Oracle BIN_TO_NUM Function

    A few examples of the BIN_TO_NUM function.
    SQL 17 views posted 2 years ago by bbrumm
  13. FAV

    Oracle CUME_DIST Function

    A few examples of the CUME_DIST function.
    SQL 11 views posted 2 years ago by bbrumm
  14. FAV

    Oracle CHARTOROWID Function

    A few examples of the CHARTOROWID function.
    SQL 9 views posted 2 years ago by bbrumm
  15. FAV

    Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions

    A few examples of the ASIN, function.
    SQL 7 views posted 2 years ago by bbrumm
  16. FAV

    Oracle GROUP_ID Function

    A few examples of the GROUP_ID function.
    SQL 14 views posted 2 years ago by bbrumm
  17. FAV

    Oracle EMPTY_CLOB Function

    A few examples of the EMPTY_CLOB function.
    SQL 10 views posted 2 years ago by bbrumm
  18. FAV

    Oracle EMPTY_BLOB Function

    A few examples of the EMPTY_BLOB function.
    SQL 9 views posted 2 years ago by bbrumm
  19. FAV

    Oracle NEW_TIME Function

    A few examples of the NEW_TIME function.
    SQL 11 views posted 2 years ago by bbrumm
  20. FAV

    Oracle TO_SINGLE_BYTE Function

    A few examples of the TO_SINGLE_BYTE function.
    SQL 8 views posted 2 years ago by bbrumm
  21. FAV

    Oracle NCHR Function

    A few examples of the NCHR function.
    SQL 10 views posted 2 years ago by bbrumm
  22. FAV

    Oracle NANVL Function

    A few examples of the NANVL function.
    SQL 10 views posted 2 years ago by bbrumm
  23. FAV

    Oracle DECOMPOSE Function

    A few examples of the DECOMPOSE function.
    SQL 9 views posted 2 years ago by bbrumm
  24. FAV

    Oracle COMPOSE Function

    A few examples of the COMPOSE function.
    SQL 13 views posted 2 years ago by bbrumm
  25. FAV

    Oracle TO_LOB Function

    A few examples of the TO_LOB function.
    SQL 14 views posted 2 years ago by bbrumm
  26. FAV

    Oracle LOCALTIMESTAMP Function

    A few examples of the LOCALTIMESTAMP function.
    SQL 6 views posted 2 years ago by bbrumm
  27. FAV

    Oracle ASCIISTR Function

    A few examples of the ASCIISTR function.
    SQL 12 views posted 2 years ago by bbrumm
  28. FAV

    Oracle TO_NCLOB Function

    A few examples of the TO_NCLOB function.
    SQL 9 views posted 2 years ago by bbrumm
  29. FAV

    Oracle TO_CLOB Function

    A few examples of the TO_CLOB function.
    SQL 9 views posted 2 years ago by bbrumm
  30. FAV

    Oracle STDDEV Function

    A few examples of the STDDEV function.
    SQL 9 views posted 2 years ago by bbrumm
« Prev 1 2 3 4 5 ... 18