PROfile

All time reputation: 85

Achievement

first submission:submitting first snipplet

mprabhuram's Recent Snippets Tagged 'Oracle'



« Prev [Page 1 of 1] Next »
  1. FAVCASE statement to transpose rows in to columns

    SQL sql Oracle Transpose
    posted on June 13, 2013 by mprabhuram
  2. FAVCursor FOR LOOP

    SQL Oracle PLSQL saved by 1 person
    posted on September 8, 2010 by mprabhuram
  3. FAVElapsed Time Calculation & SLEEP

    SQL Oracle PLSQL
    posted on August 31, 2010 by mprabhuram
  4. FAVGenerate HASH Value for a string

    SQL Oracle saved by 2 people
    posted on August 31, 2010 by mprabhuram
  5. FAVReturn Database Version

    SQL Oracle PLSQL
    posted on August 31, 2010 by mprabhuram
  6. FAVDynamic SQL - Stored procedure

    SQL Oracle PLSQL saved by 2 people
    posted on August 30, 2010 by mprabhuram
  7. FAVVariable Declaration Using Database Objects %rowtype

    SQL Oracle PLSQL saved by 1 person
    posted on August 30, 2010 by mprabhuram
  8. FAVLogic to subtract months from a date field and extract run_yr_mo

    SQL Oracle
    posted on August 20, 2010 by mprabhuram
  9. FAVOracle Sequence

    SQL Oracle
    posted on August 14, 2010 by mprabhuram
  10. FAVPush_subq Oracle hint - Execute the sub query before the parent query

    SQL Oracle hints SmartySQL
    posted on July 7, 2010 by mprabhuram
  11. FAVCreate/ View/ Delete DB Links in oracle

    SQL sql Oracle
    posted on July 7, 2010 by mprabhuram
  12. FAVOracle TimeStamp to Char conversion

    SQL sql Oracle
    posted on July 2, 2010 by mprabhuram
  13. FAVRegular expression to convert alphanumeric field into numeric field

    SQL Oracle loannumberconversion
    posted on June 21, 2010 by mprabhuram
  14. FAVHow to avoid double counting

    SQL sql Oracle SmartySQL saved by 1 person
    posted on June 4, 2010 by mprabhuram
  15. FAVOracle - Overlaps function

    SQL sql Oracle SmartySQL
    posted on June 4, 2010 by mprabhuram
  16. FAVRanking Function - Range over partition - Oracle Analytical function

    SQL sql Oracle BY group partition analyticalfunction rownumber
    posted on May 19, 2010 by mprabhuram
« Prev [Page 1 of 1] Next »