• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

login / Register

Share Snipplr

Tools

• Textmate Bundle
• WordPress Plugin
• Snippets

Popular Tags

Everyone's Recent SQL Snippets Tagged 'Oracle'

• All / 
• JavaScript / 
• HTML / 
• PHP / 
• CSS / 
• Ruby / 
• Objective C

1. Regular expression to convert alphanumeric field into numeric field

   SQL Oracle loannumberconversion
   posted on June 21, 2010 by mprabhuram

2. How to avoid double counting

   SQL sql Oracle SmartySQL saved by 1 person
   posted on June 4, 2010 by mprabhuram

3. Oracle - Overlaps function

   SQL sql Oracle SmartySQL
   posted on June 4, 2010 by mprabhuram

4. Ranking Function - Range over partition - Oracle Analytical function

   SQL sql Oracle BY group partition analyticalfunction rownumber
   posted on May 19, 2010 by mprabhuram

5. ORACLE 获取表所占用空间大小计算和展示

   SQL Oracle
   posted on March 1, 2010 by mifly

6. Find table by column name

   SQL sql search name Oracle field column saved by 2 people
   posted on February 24, 2010 by andreiabohner

7. create dblink

   SQL Oracle
   posted on February 24, 2010 by mifly

8. 移表和索引的表空间

   SQL Oracle
   posted on February 22, 2010 by mifly

9. oracle 导入导出命令 exp例子

   SQL Oracle
   posted on February 21, 2010 by mifly

10. 查看oracle redo size 的sql

    SQL Oracle
    posted on January 19, 2010 by mifly

11. oracle 性能监控 sql

    SQL sql Oracle
    posted on January 19, 2010 by mifly

12. Select to read content of a CLOB column with Oracle DB

    SQL database sql content read Oracle clob
    posted on December 27, 2009 by andreiabohner

13. Oracle SQL - Select OAF File version history

    SQL database sql version Oracle history application Framework OAF
    posted on April 14, 2009 by theonlyalterego

14. Selecting a Random Row From Oracle

    SQL Oracle saved by 1 person
    posted on January 21, 2009 by jordantbro

15. Convert an Oracle SQL DATE to a STRING in the form CCYYMMDD

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

16. Copy table into a new table

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

17. Generate the SQL necessary to create triggers (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

18. Generate the SQL necessary to create sequences for every table (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

19. Get a list of all the user tables (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

20. Get Columns and Comments (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

21. Strip(i.e. remove) special character(s)

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

22. Simple Technique to Subtract Years from an Oracle Date

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

23. List all Stored Procedures in an Oracle Database

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

24. Oracle DateTime Interval

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

25. Oracle Stored Proc to Return a Recordset (Oracle Side)

    SQL Oracle PLSQL StoredProc
    posted on July 25, 2006 by rengber