if ( (LENGTH(TRIM(TRANSLATE(contentcode, ‘+0123456789′,’ ‘))) is not null) or (LENGTH(TRIM(TRANSLATE(otherfield, ‘+0123456789′,’ ‘))) is not null)) then dbms_output.put_line(‘contentcode or otherfield is invalid’);
Faced with a tedious task of ordering a set of rows using a weight column? Don’t want to type the numbers out? Would rather find a difficult but more interesting method? I have the answer for you! In Drupal, menu items (like the projects list on this site) are ordered… read more →
SQL is a functional language. Try to think of a SELECT statement as a function. That is, a mathematical function, or mapping, which — this is important — maps an input to an output. When you select data from a table, think of the table as a source. Data streams… read more →