Snipplr - indianocean http://snipplr.com/users/indianocean/tags/Oracle Recent snippets posted on Snipplr.com en-us Sat, 11 Oct 2008 21:20:04 GMT (SQL) Multiple inserts http://snipplr.com/view/6492/multiple-inserts/

]]> Thu, 29 May 2008 09:50:41 GMT http://snipplr.com/view/6492/multiple-inserts/ (SQL) Simple Oracle Trigger http://snipplr.com/view/6115/simple-oracle-trigger/

]]> Mon, 05 May 2008 11:00:42 GMT http://snipplr.com/view/6115/simple-oracle-trigger/ (SQL) Simple Oracle stored procedure http://snipplr.com/view/5567/simple-oracle-stored-procedure/ Just a template...

]]> Wed, 26 Mar 2008 06:51:42 GMT http://snipplr.com/view/5567/simple-oracle-stored-procedure/ (SQL) GROUP BY with Date http://snipplr.com/view/3565/group-by-with-date/

]]> Fri, 24 Aug 2007 08:05:45 GMT http://snipplr.com/view/3565/group-by-with-date/ (SQL) Finding calendar week to given date http://snipplr.com/view/3530/finding-calendar-week-to-given-date/

]]> Fri, 17 Aug 2007 02:23:46 GMT http://snipplr.com/view/3530/finding-calendar-week-to-given-date/ (SQL) Extract date part http://snipplr.com/view/3523/extract-date-part/

]]> Thu, 16 Aug 2007 07:17:47 GMT http://snipplr.com/view/3523/extract-date-part/ (SQL) Compare or search for DATE in Oracle http://snipplr.com/view/3379/compare-or-search-for-date-in-oracle/ A simple SELECT * FROM PRODUCTS where date_lastmodified = to_date('25.07.07') doesn't work though date_lastmodified is not a dts.

]]> Wed, 25 Jul 2007 05:50:43 GMT http://snipplr.com/view/3379/compare-or-search-for-date-in-oracle/ (SQL) Faster "select from where NOT in" http://snipplr.com/view/1793/faster-select-from-where-not-in/ Same result as: "select from where NOT in" but faster. The result is: all customers that don't have orders.

]]> Wed, 13 Dec 2006 00:48:46 GMT http://snipplr.com/view/1793/faster-select-from-where-not-in/