dave's blog

Nutritional Information from the USDA…

The USDA supplies a Nutritional Database. It has about 7300 foods and associated nutritional information. Most of the foods are the simplified components instead of brand names, but its usually easy enough to find equivalents. It can also be used as a jumping off point for a more comprehensive database.

Info about the information supplied: http://www.nal.usda.gov/fnic/foodcomp/Data/SR19/sr19_doc.pdf


Using SQLPLUS to generate scripts…

Tired of updating scripts by searching and replacing until your fingers fall off? Have a SQL statement you have to run against every table in your schema?

Next to Regular Expressions, this is one of the most useful tools in my arsenal.

Common uses for this are to write SQL statements that can work from a list of objects in the database:


Subscribe to RSS - dave's blog