Snipplr - indianocean http://snipplr.com/users/indianocean/tags/sql Recent snippets posted on Snipplr.com en-us Sun, 07 Sep 2008 09:00:25 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/ (Java) Check if reultset is empty without side effect http://snipplr.com/view/3403/check-if-reultset-is-empty-without-side-effect/

]]> Fri, 27 Jul 2007 05:42:28 GMT http://snipplr.com/view/3403/check-if-reultset-is-empty-without-side-effect/ (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/ (Java) Simple SQL Statement using OpenCMS http://snipplr.com/view/3353/simple-sql-statement-using-opencms/

]]> Tue, 24 Jul 2007 01:36:56 GMT http://snipplr.com/view/3353/simple-sql-statement-using-opencms/ (SQL) SELECT with date working in every locale http://snipplr.com/view/3346/select-with-date-working-in-every-locale/

]]> Mon, 23 Jul 2007 05:41:40 GMT http://snipplr.com/view/3346/select-with-date-working-in-every-locale/