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

• Big /
• Small

mprabhuram

Member since 07/14/2009

15 snippets

View their favorites

Their Tags

PROfile

All time reputation: 21

mprabhuram's Recent Snippets Tagged 'Oracle'

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

1. Cursor FOR LOOP

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

2. Elapsed Time Calculation & SLEEP

   SQL Oracle PLSQL
   posted on August 31, 2010 by mprabhuram

3. Generate HASH Value for a string

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

4. Return Database Version

   SQL Oracle PLSQL
   posted on August 31, 2010 by mprabhuram

5. Dynamic SQL - Stored procedure

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

6. Variable Declaration Using Database Objects %rowtype

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

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

   SQL Oracle
   posted on August 20, 2010 by mprabhuram

8. Oracle Sequence

   SQL Oracle
   posted on August 14, 2010 by mprabhuram

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

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

10. Create/ View/ Delete DB Links in oracle

    SQL sql Oracle
    posted on July 7, 2010 by mprabhuram

11. Oracle TimeStamp to Char conversion

    SQL sql Oracle
    posted on July 2, 2010 by mprabhuram

12. Regular expression to convert alphanumeric field into numeric field

    SQL Oracle loannumberconversion
    posted on June 21, 2010 by mprabhuram

13. How to avoid double counting

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

14. Oracle - Overlaps function

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

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

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