• 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. Search DDL (stored procedures, functions, etc) for keywords

   SQL sql search server Oracle DDL
   posted on April 5, 2012 by jstrawther

2. Oracle AP-SLA-GL Link Query

   SQL Oracle R12 GL ap SLA AP-SLA-GL r1213
   posted on January 21, 2012 by theonlyalterego

3. Oracle - get concurrent program runtime / eval performance

   SQL Oracle program Concurrent apps
   posted on January 21, 2012 by theonlyalterego

4. Query to find Parameters and Value Sets associated with a Concurrent Program

   SQL sql Oracle Fnd
   posted on January 21, 2012 by theonlyalterego

5. Oracle SQL - get a list of most recent user logins

   SQL sql Oracle
   posted on December 23, 2011 by theonlyalterego

6. Oracle - Find which users have FND Diagnostic profile value set

   SQL sql Oracle diagnostic
   posted on October 26, 2011 by theonlyalterego

7. Connect string for Oracle with sqlplus

   SQL sql Oracle saved by 1 person
   posted on October 11, 2011 by blackthorne

8. Oracle - Find all responsibilities and concurrent program names based on the executable Name

   SQL sql search Oracle find program Concurrent responsibility
   posted on July 28, 2011 by theonlyalterego

9. test snippet 2

   SQL sql Oracle
   posted on June 30, 2011 by mariolassnig

10. test snippet

    SQL sql Oracle
    posted on June 30, 2011 by mariolassnig

11. Oracle - sql to find what responsibility can run a request / report

    SQL sql Oracle
    posted on June 24, 2011 by theonlyalterego

12. Cambiare tipo in colonna ORACLE

    SQL sql type Oracle
    posted on May 5, 2011 by tuffo19

13. Test String is numeric

    SQL Oracle
    posted on April 1, 2011 by marvin9000

14. Return a random sample of 5% of records of a table with Oracle

    SQL Oracle
    posted on January 28, 2011 by xavsio4

15. Compare dates in Business Objects Data Integrator with Oracle

    SQL Oracle etl BODI
    posted on January 28, 2011 by xavsio4

16. Get all tables and views having this field in their structure

    SQL Oracle DBA
    posted on January 28, 2011 by xavsio4

17. Random Row(s)

    SQL sql Oracle
    posted on December 8, 2010 by geekzspot

18. select a random sample (percentage) of data

    SQL sql Oracle
    posted on December 7, 2010 by geekzspot

19. boolean column for oracle database tables

    SQL database Oracle DDL
    posted on December 7, 2010 by geekzspot

20. Oracle Applications - Find Application (Module) Long Name from Short name

    SQL Oracle apps Applications oracleapplications
    posted on November 6, 2010 by theonlyalterego

21. View active sessions in Oracle

    SQL Oracle DBA
    posted on October 21, 2010 by xavsio4

22. Cursor FOR LOOP

    SQL Oracle PLSQL saved by 1 person
    posted on September 8, 2010 by mprabhuram

23. Elapsed Time Calculation & SLEEP

    SQL Oracle PLSQL
    posted on August 31, 2010 by mprabhuram

24. Generate HASH Value for a string

    SQL Oracle saved by 2 people
    posted on August 31, 2010 by mprabhuram

25. Return Database Version

    SQL Oracle PLSQL
    posted on August 31, 2010 by mprabhuram

26. Dynamic SQL - Stored procedure

    SQL Oracle PLSQL saved by 2 people
    posted on August 30, 2010 by mprabhuram

27. Variable Declaration Using Database Objects %rowtype

    SQL Oracle PLSQL saved by 1 person
    posted on August 30, 2010 by mprabhuram

28. Logic to subtract months from a date field and extract run_yr_mo

    SQL Oracle
    posted on August 20, 2010 by mprabhuram

29. Oracle Sequence

    SQL Oracle
    posted on August 14, 2010 by mprabhuram

30. Push_subq Oracle hint - Execute the sub query before the parent query

    SQL Oracle hints SmartySQL
    posted on July 7, 2010 by mprabhuram

31. Create/ View/ Delete DB Links in oracle

    SQL sql Oracle
    posted on July 7, 2010 by mprabhuram

32. Oracle TimeStamp to Char conversion

    SQL sql Oracle
    posted on July 2, 2010 by mprabhuram

33. Regular expression to convert alphanumeric field into numeric field

    SQL Oracle loannumberconversion
    posted on June 21, 2010 by mprabhuram

34. How to avoid double counting

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

35. Oracle - Overlaps function

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

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

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

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

    SQL Oracle
    posted on March 1, 2010 by mifly

38. Find table by column name

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

39. create dblink

    SQL Oracle
    posted on February 24, 2010 by mifly

40. 移表和索引的表空间

    SQL Oracle
    posted on February 22, 2010 by mifly