SQL oracle: don’t show empty values.

Jan29
  • Share

Difficulty: ★★☆☆☆

Ever wanted to query a resultset and received a whole bunch of results with empty values?
Just query on select no empty values.
The query can look like this:

SELECT * FROM MY_TABLE WHERE CD_VAL = 'something' AND CD_VAL IS NOT NULL;

One Response to “SQL oracle: don’t show empty values.”

koool thx or the query sample

Oracle Training Pakistan on December 13th, 2009 at 4:13 AM

Leave a comment