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

• Big /
• Small

stews

Member since 09/17/2008

7 snippets

View their favorites

Their Tags

PROfile

All time reputation: 4

stews' Recent PL/SQL Snippets

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

1. Function to get first record from query and return single value

   PL/SQL query first
   posted on September 17, 2008 by stews

2. Refresh an Oracle materialized view

   PL/SQL view refresh materialized
   posted on September 17, 2008 by stews

3. Record Exists function template

   PL/SQL table exist
   posted on September 17, 2008 by stews

4. Efficiently compare results from two queries

   PL/SQL compare Subquery
   posted on September 17, 2008 by stews

5. Efficiently compare columns from two tables

   PL/SQL compare Oracle Asktom
   posted on September 17, 2008 by stews

6. UPDATE using WHERE CURRENT OF clause

   PL/SQL update where of current
   posted on September 17, 2008 by stews

7. INSERT rows from BULK COLLECT with LIMIT clause

   PL/SQL loop limit bulk collect saved by 1 person
   posted on September 17, 2008 by stews