Oracle - Return Invalid Canada Postal codes
<p>I am trying to run this query which doesn't return any records. I know there are invalid postal codes however it doesn't work.</p>

<pre><code>select * 
from ADDR_TAB 
where  ZIPCODE not like ('[ABCEGHJ-NPRSTVXY][0-9][ABCEGHJ-NPRSTV-Z][0-9][ABCEGHJ-NPRSTV-Z][0-9]');
</code></pre>

<p>Also tried, </p>

<pre><code>select * 
from ADDR_TAB 
where  ZIPCODE not like ('[A-Z][0-9][A-Z][0-9][A-Z][0-9]');
</code></pre>