Archive for June, 2009
Raised bed garden- first fruit!
Gabe did the honors of plucking our first garden vegetable today. We chopped up the banana pepper, it was full of fresh-from-the-garden goodness:
Posted in general | No Comments »Numeric validation with Oracle regexp_like
PROBLEM: Identify records where there is non-numeric values for a particular column. SOLUTION: select SOME_COL from SOME_TBL where regexp_like (SOME_COL,’^[^[:digit:]]’) ; Obviously this implies that maybe the field should be a NUMBER datatype to start with, but sometimes what we want, what we should have, and what we actually have are not the same thing.
Posted in oracle/database | No Comments »Garden progress
Our little raised bed garden experiment is moving along nicely. The tomato plants have grown up enough to warrant some bamboo trellis support: The cell phone picture doesn’t show a lot of detail, but the tomatoes are down the middle, and that is basil up front right and the tall stuff flowering in the back [...]
Posted in general | No Comments »