How to format Zip -code (XXXXX-XXXX) for country USA?
<p>There is a requirement to display a formatted US Zip code on screen from a oracle view given below, the zip code should be formatted XXXXX-XXXX only if country code is US and length of zip-code is 9-digits.</p>

<pre><code>CREATE OR REPLACE VIEW PARTY_ADDR
AS 
SELECT ZIP_CODE AS ZIP_POSTAL_CODE,COUNTRY_CD,ADDRESS_LINE_1  
FROM PARTY
</code></pre>