http://snipplr.com/users/thecrumb/language/sql Recent snippets posted on Snipplr.com en-us Tue, 02 Dec 2008 03:34:56 GMT 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/ 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/ 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/ 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/