advanced code snippet search

login / Register

Write an Article

Do you have experience with SQL? Write an article and have it published on this page and in the blog!

We Recommend

SQL Cookbook SQL Cookbook
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

Share Snipplr

del.icio.us Digg Furl Reddit

Plugins

Popular Tags

Abbreviation BY BitMask CTE DBA DDL DateTime Oracle PLSQL StoredProc String StringHandling Subquery Technique Troubleshooting administration adminitration backup buscar character cli code column commands console conversion count created csv currency data database date db db2 detectivework drupal dump error espaa excel fulltext geonames grant increment insert ip4 key last list login maintainance mssql mysql nodes order paginate password performance php postgres primary privileges procedure provincias queries query random remote remove replace sanitychecks script search select server sorting special sproc sql sqlserver states statistics stored table template text timestamp trac transact-sql transaction trigger tsql update users vertical xml zipcodes

Everyone's Recent SQL Snippets Tagged 'Oracle'

« Prev [Page 1 of 1] Next »

  1. [ ]Convert an Oracle SQL DATE to a STRING in the form CCYYMMDD

    SQL sql Oracle dates
    posted on July 29, 2008 by retry

  2. [ ]Multiple inserts

    SQL sql Oracle
    posted on May 29, 2008 by indianocean

  3. [ ]Simple Oracle Trigger

    SQL sql Oracle PLSQL sp
    posted on May 5, 2008 by indianocean

  4. [ ]Simple Oracle stored procedure

    SQL sql template stored procedure Oracle
    posted on March 26, 2008 by indianocean

  5. [ ]Copy table into a new table

    SQL sql Oracle saved by 1 person
    posted on January 29, 2008 by Caliban

  6. [ ]Generate the SQL necessary to create triggers (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

  7. [ ]Generate the SQL necessary to create sequences for every table (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

  8. [ ]Get a list of all the user tables (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

  9. [ ]Get Columns and Comments (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

  10. [ ]Strip(i.e. remove) special character(s)

    SQL character strip function remove Oracle special
    posted on October 14, 2007 by spacebar

  11. [ ]Simple Technique to Subtract Years from an Oracle Date

    SQL Oracle PLSQL DateTime
    posted on September 25, 2007 by rengber

  12. [ ]List all Stored Procedures in an Oracle Database

    SQL database sql Oracle StoredProc DBA PSQL
    posted on September 24, 2007 by rengber

  13. [ ]GROUP BY with Date

    SQL sql date Oracle saved by 2 people
    posted on August 24, 2007 by indianocean

  14. [ ]Finding calendar week to given date

    SQL sql date Oracle
    posted on August 17, 2007 by indianocean

  15. [ ]Extract date part

    SQL sql date Oracle
    posted on August 16, 2007 by indianocean

  16. [ ]Compare or search for DATE in Oracle

    SQL sql date Oracle
    posted on July 25, 2007 by indianocean

  17. [ ]Faster "select from where NOT in"

    SQL Oracle saved by 3 people
    posted on December 13, 2006 by indianocean

  18. [ ]Oracle DateTime Interval

    SQL Oracle PLSQL DateTime
    posted on July 30, 2006 by rengber

  19. [ ]Oracle Stored Proc to Return a Recordset (Oracle Side)

    SQL Oracle PLSQL StoredProc
    posted on July 25, 2006 by rengber
« Prev [Page 1 of 1] Next »