title: How to format Zip -code (XXXXX-XXXX) for country USA?
body: <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>