Category Archives: oracle/sqlserver/database

How to find non printing characters using instr and regexp_instr in Oracle databases:

Two more examples of regexp_like for the memory banks: — convert to NULL if SOME_COL is not A,B,C,1,2,or 3 case when (regexp_like(a.SOME_COL,'[^A-C1-3]’)) then NULL else a.SOME_COL end as SOME_COL, — convert to 0000 if the col’s value is not a … Continue reading →

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 … Continue reading →

Geek blog [Slashdot] has been abuzz since it was announced that [MySql], darlings and key ingredient of the [LAMP] explosion, is doing business with SCO, the absolute scourge of the Linux world. Now that MySQL has been associated with the … Continue reading →

DECODE- better than an Ovaltine Little Orphan Annie Decoder Ring Continue reading →