Category Archives: oracle/sqlserver/database

oracle and sql server hints and tips

Nerd alert: Finding non-printing characters in varchar2 fields in Oracle

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

Posted in oracle/sqlserver/database | 1 Comment

More Oracle regexp_like

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

Posted in oracle/sqlserver/database | Leave a comment

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

Posted in oracle/sqlserver/database | Leave a comment

MySQL Gotchas

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

Posted in oracle/sqlserver/database | Leave a comment

Oracle and DECODE- updated

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

Posted in oracle/sqlserver/database | Leave a comment