Snipplr http://snipplr.com/language/sql/tags/sql Recent snippets posted on Snipplr.com en-us Thu, 21 Aug 2008 19:16:25 GMT (SQL) Convert an Oracle SQL DATE to a STRING in the form CCYYMMDD - retry http://snipplr.com/view/7573/convert-an-oracle-sql-date-to-a-string-in-the-form-ccyymmdd/ This Oracle SQL snippet converts an Oracle SQL DATE to a STRING in the form CCYYMMDD.

]]> Tue, 29 Jul 2008 03:52:15 GMT http://snipplr.com/view/7573/convert-an-oracle-sql-date-to-a-string-in-the-form-ccyymmdd/ (SQL) Multiple inserts - indianocean http://snipplr.com/view/6492/multiple-inserts/

]]> Thu, 29 May 2008 09:50:41 GMT http://snipplr.com/view/6492/multiple-inserts/ (SQL) Comma-Delimited List using Coalesce - mcbutterbuns http://snipplr.com/view/6367/commadelimited-list-using-coalesce/ If you ever need to build a comma delimited list out of a column in SQL you can easily do this using the COALESCE function.

]]> Tue, 20 May 2008 17:50:43 GMT http://snipplr.com/view/6367/commadelimited-list-using-coalesce/ (SQL) Simple Oracle Trigger - indianocean 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) Grant MySQL Privileges - cbrant http://snipplr.com/view/5695/grant-mysql-privileges/ To grant all privileges to a user from any location login to the mysql shell and run the following queries.

]]> Fri, 04 Apr 2008 03:52:39 GMT http://snipplr.com/view/5695/grant-mysql-privileges/ (SQL) Set MySQL root password - cbrant http://snipplr.com/view/5694/set-mysql-root-password/ To reset the MySQL root password, login to the mysql shell and run the following commands.

]]> Fri, 04 Apr 2008 03:48:37 GMT http://snipplr.com/view/5694/set-mysql-root-password/ (SQL) Simple Oracle stored procedure - indianocean 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) TSQL for Recursive Select Using Common Table Expressions - rengber http://snipplr.com/view/5547/tsql-for-recursive-select-using-common-table-expressions/

]]> Mon, 24 Mar 2008 18:00:18 GMT http://snipplr.com/view/5547/tsql-for-recursive-select-using-common-table-expressions/ (SQL) SQL To Show WaitTime and other Process Stats - rengber http://snipplr.com/view/5498/sql-to-show-waittime-and-other-process-stats/

]]> Wed, 19 Mar 2008 22:55:37 GMT http://snipplr.com/view/5498/sql-to-show-waittime-and-other-process-stats/ (SQL) TSQL to Concatenate Subquery Row Values into a Column Value - rengber http://snipplr.com/view/5497/tsql-to-concatenate-subquery-row-values-into-a-column-value/

]]> Wed, 19 Mar 2008 22:54:33 GMT http://snipplr.com/view/5497/tsql-to-concatenate-subquery-row-values-into-a-column-value/ (SQL) Update from select - wolfie http://snipplr.com/view/5150/update-from-select/

]]> Thu, 21 Feb 2008 11:56:51 GMT http://snipplr.com/view/5150/update-from-select/ (SQL) TSQL to Reset a Tables Primary Key Autonumber - rengber http://snipplr.com/view/5102/tsql-to-reset-a-tables-primary-key-autonumber/

]]> Sun, 17 Feb 2008 20:42:49 GMT http://snipplr.com/view/5102/tsql-to-reset-a-tables-primary-key-autonumber/ (SQL) Date 0000-00-00 - Abe http://snipplr.com/view/5019/date-00000000/ An easy way to handle null dates. If date = 0000-00-00 then null, else use date

]]> Tue, 12 Feb 2008 10:21:20 GMT http://snipplr.com/view/5019/date-00000000/ (SQL) Differences between two Tables - zingo http://snipplr.com/view/4869/differences-between-two-tables/

]]> Fri, 01 Feb 2008 04:26:53 GMT http://snipplr.com/view/4869/differences-between-two-tables/ (SQL) Copy table into a new table - Caliban http://snipplr.com/view/4817/copy-table-into-a-new-table/

]]> Tue, 29 Jan 2008 10:23:26 GMT http://snipplr.com/view/4817/copy-table-into-a-new-table/ (SQL) MySQL Dump - Abe http://snipplr.com/view/4767/mysql-dump/

]]> Thu, 24 Jan 2008 10:47:32 GMT http://snipplr.com/view/4767/mysql-dump/ (SQL) Generate the SQL necessary to create triggers (Oracle) - thecrumb http://snipplr.com/view/4750/generate-the-sql-necessary-to-create-triggers-oracle/ Generate the SQL necessary to create triggers that use the sequences listed above. NOTE: This particular script assumes that the tables all start with ‘tbl’. It may need to be modified to work with different naming conventions.

]]> Wed, 23 Jan 2008 14:17:25 GMT http://snipplr.com/view/4750/generate-the-sql-necessary-to-create-triggers-oracle/ (SQL) Generate the SQL necessary to create sequences for every table (Oracle) - thecrumb http://snipplr.com/view/4749/generate-the-sql-necessary-to-create-sequences-for-every-table-oracle/ Generate the SQL necessary to create sequences for every table. NOTE: This doesn’t create sequences. The results need to be copied and run as a script.

]]> Wed, 23 Jan 2008 14:15:25 GMT http://snipplr.com/view/4749/generate-the-sql-necessary-to-create-sequences-for-every-table-oracle/ (SQL) Get a list of all the user tables (Oracle) - thecrumb http://snipplr.com/view/4748/get-a-list-of-all-the-user-tables-oracle/ Get a list of all the user tables.

]]> Wed, 23 Jan 2008 14:14:14 GMT http://snipplr.com/view/4748/get-a-list-of-all-the-user-tables-oracle/ (SQL) Get Columns and Comments (Oracle) - thecrumb http://snipplr.com/view/4747/get-columns-and-comments-oracle/ Get all my columns and comments.

]]> Wed, 23 Jan 2008 14:13:05 GMT http://snipplr.com/view/4747/get-columns-and-comments-oracle/