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

• Big /
• Small

Top Users

•  chrisaiv (285)
•  jerryvig (264)
•  girliegeek (213)
•  scott2b (208)
•  noah (207)
•  narkisr (188)
•  ljayz (185)
•  adrianparr (180)
•  1man (166)
•  Scooter (158)

Popular Tags

Popular SQL Snippets Tagged 'Oracle'

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

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

1. Search all PL/SQL

   SQL Oracle saved by 2 people
   posted on October 12, 2012 by geekzspot

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. Oracle Database Version

   SQL database Oracle saved by 1 person
   posted on October 23, 2012 by geekzspot

6. Search all Oracle columns

   SQL Oracle saved by 1 person
   posted on October 12, 2012 by geekzspot

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

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

8. Connect string for Oracle with sqlplus

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

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

   SQL Oracle saved by 1 person
   posted on January 28, 2011 by xavsio4

10. Cursor FOR LOOP

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

11. Variable Declaration Using Database Objects %rowtype

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

12. How to avoid double counting

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

13. Selecting a Random Row From Oracle

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

14. Copy table into a new table

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

15. Add a GUID Primary Key column to an exsiting Table (script).

    SQL Oracle
    posted on November 29, 2012 by geekzspot

16. Rechte granten

    SQL sql Oracle rechte
    posted on November 19, 2012 by devtek

17. Ver tablas asignadas a un usuario por privilegios

    SQL sql Oracle DBA privilegios
    posted on November 14, 2012 by thescorpion

18. Grant y Revoke sobre objetos - dinamico

    SQL sql Oracle DBA privilegios
    posted on November 14, 2012 by thescorpion

19. Oracle Random Decimal Number

    SQL sql Oracle
    posted on October 23, 2012 by geekzspot

20. Oracle SQL to change double quotes to single quotes

    SQL sql Oracle
    posted on October 23, 2012 by geekzspot

21. Creacion de DBLINK con Full name service

    SQL sql Oracle PLSQL DBA
    posted on October 20, 2012 by thescorpion

22. Mostrar JOB

    SQL sql Oracle PLSQL DBA
    posted on October 20, 2012 by thescorpion

23. Mostrar Objetos que hacen Referencia a un Objeto Especifico

    SQL sql Oracle PLSQL DBA
    posted on October 12, 2012 by thescorpion

24. Borra archivos LOG Oracle usando RMAN

    SQL sql Oracle PLSQL DBA
    posted on September 29, 2012 by thescorpion

25. Oracle Find Profile Values for User

    SQL sql Oracle diagnostic
    posted on August 10, 2012 by theonlyalterego

26. Oracle AP-SLA-GL Link Query

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

27. Oracle - get concurrent program runtime / eval performance

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

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

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

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

    SQL sql Oracle
    posted on December 23, 2011 by theonlyalterego

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

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

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

32. test snippet 2

    SQL sql Oracle
    posted on June 30, 2011 by mariolassnig

33. test snippet

    SQL sql Oracle
    posted on June 30, 2011 by mariolassnig

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

    SQL sql Oracle
    posted on June 24, 2011 by theonlyalterego

35. Cambiare tipo in colonna ORACLE

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

36. Test String is numeric

    SQL Oracle
    posted on April 1, 2011 by marvin9000

37. Compare dates in Business Objects Data Integrator with Oracle

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

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

    SQL Oracle DBA
    posted on January 28, 2011 by xavsio4

39. Random Row(s)

    SQL sql Oracle
    posted on December 8, 2010 by geekzspot

40. select a random sample (percentage) of data

    SQL sql Oracle
    posted on December 7, 2010 by geekzspot