• 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. How to avoid double counting

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

2. Oracle - Overlaps function

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

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

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

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

   SQL Oracle
   posted on March 1, 2010 by mifly

5. Find table by column name

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

6. create dblink

   SQL Oracle
   posted on February 24, 2010 by mifly

7. 移表和索引的表空间

   SQL Oracle
   posted on February 22, 2010 by mifly

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

   SQL Oracle
   posted on February 21, 2010 by mifly

9. 查看oracle redo size 的sql

   SQL Oracle
   posted on January 19, 2010 by mifly

10. oracle 性能监控 sql

    SQL sql Oracle
    posted on January 19, 2010 by mifly

11. 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

12. Oracle SQL - Select OAF File version history

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

13. Selecting a Random Row From Oracle

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

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

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

15. Copy table into a new table

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

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

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

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

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

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

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

19. Get Columns and Comments (Oracle)

    SQL sql Oracle
    posted on January 23, 2008 by thecrumb

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

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

21. Simple Technique to Subtract Years from an Oracle Date

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

22. List all Stored Procedures in an Oracle Database

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

23. Oracle DateTime Interval

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

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

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