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

• Big /
• Small

Top Users

•  chrisaiv (269)
•  jerryvig (253)
•  girliegeek (213)
•  scott2b (208)
•  noah (207)
•  narkisr (188)
•  adrianparr (170)
•  1man (166)
•  ljayz (163)
•  Scooter (158)

Popular Tags

Popular Snippets Tagged 'Oracle'

• All time
•  / week
•  / month
•  / year

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

1. Faster "select from where NOT in"

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

2. Generate HASH Value for a string

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

3. Dynamic SQL - Stored procedure

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

4. Find table by column name

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

5. Connect string for Oracle with sqlplus

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

6. Conexión manual a Base de Datos ORACLE

   Java java Oracle saved by 1 person
   posted on January 8, 2011 by skayme

7. Cursor FOR LOOP

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

8. Variable Declaration Using Database Objects %rowtype

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

9. How to avoid double counting

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

10. LoneDatabaseClass

    PHP mysql database sql php mssql Oracle saved by 1 person
    posted on March 5, 2010 by coevolve

11. Copy table into a new table

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

12. Search DDL (stored procedures, functions, etc) for keywords

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

13. Import CSV into Oracle TimesTen

    Bash sql import Oracle csv timesten
    posted on March 1, 2012 by jerryvig

14. Oracle AP-SLA-GL Link Query

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

15. Oracle - get concurrent program runtime / eval performance

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

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

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

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

    SQL sql Oracle
    posted on December 23, 2011 by theonlyalterego

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

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

19. Oracle - compile report / compile forms on linux

    Bash forms unix linux compile Oracle report
    posted on July 29, 2011 by theonlyalterego

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

21. Strategy to identify duplicates in an ETL context (for example)

    PL/SQL sql Oracle etl BODI
    posted on July 9, 2011 by xavsio4

22. test snippet 2

    SQL sql Oracle
    posted on June 30, 2011 by mariolassnig

23. test snippet

    SQL sql Oracle
    posted on June 30, 2011 by mariolassnig

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

    SQL sql Oracle
    posted on June 24, 2011 by theonlyalterego

25. Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user

    PL/SQL sql Oracle PLSQL OAF
    posted on May 26, 2011 by theonlyalterego

26. Cambiare tipo in colonna ORACLE

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

27. Oracle - Iterating Cursor

    PL/SQL Oracle
    posted on April 23, 2011 by Hisoka

28. Test String is numeric

    SQL Oracle
    posted on April 1, 2011 by marvin9000

29. Restart Oracle - Ubuntu

    Bash Oracle
    posted on March 6, 2011 by JohnnyGamba

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

    SQL Oracle
    posted on January 28, 2011 by xavsio4

31. Compare dates in Business Objects Data Integrator with Oracle

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

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

    SQL Oracle DBA
    posted on January 28, 2011 by xavsio4

33. Random Row(s)

    SQL sql Oracle
    posted on December 8, 2010 by geekzspot

34. select a random sample (percentage) of data

    SQL sql Oracle
    posted on December 7, 2010 by geekzspot

35. boolean column for oracle database tables

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

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

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

37. View active sessions in Oracle

    SQL Oracle DBA
    posted on October 21, 2010 by xavsio4

38. MISSING GRANTS

    PL/SQL Oracle
    posted on October 1, 2010 by kamilch

39. Update da table a table

    PL/SQL sql db Oracle
    posted on September 28, 2010 by tuffo19

40. Elapsed Time Calculation & SLEEP

    SQL Oracle PLSQL
    posted on August 31, 2010 by mprabhuram