How to set postal code format in oracle? - oracle postal code format
I have a restriction that I need to put in practice ... is as follows:
#. The format of the postcode (only for addresses in the Netherlands) will always be monitored and to be checked an appropriate format for all attributes;
How can the format of the zip code in the oracle?
and Oracle also .. I use to my database .. It is expressed as the Web version of Oracle ... We will work with Oracle Forms and ... Can I use this as an oracle database later .. I want to use Oracle as a different computer?
Thursday, February 4, 2010
Oracle Postal Code Format How To Set Postal Code Format In Oracle?
1 comment:
It would be much easier to limit your zip code for a form (VB, ASP, PHP,. NET) to care about the creation of a limitation in Oracle. Thus, if the data is entered on the form, you can compare the data do not contain any restrictions, like you before it hits the same database.
Example in ASP:
\\ \\ \\ \\ \\ \\ \\ \\ U0026lt;%
booError = False
strError = ""
StrZip = Trim (Request.Form ( "CP"))
If strZip = "" Then
booError = True
StrError = "Zip code must not be empty u0026lt \\ \\ \\ \\ \\ \\ \\ \\; br>"
Other
If IsNumeric (strZip) Then
booError = True
strError = "You are always a postcode u0026lt U.S. \\ \\ \\ \\ \\ \\ \\ \\; br>"
End If
End If
So, if booError
If u0026lt \\ \\ \\ \\ strError \\ \\ \\ \\,> "Response.Write strError
Response.Write "\\ \\ \\ \\ \\ \\ \\ \\ u0026lt; form method =" post "action = 'thisform.asp"> "
Response.Write "\\ \\ \\ \\ \\ \\ \\ \\ u0026lt; table border =" 1 "cellpadding =" 2 "cellspacing =" 2 ">"
Response.Write & quot \\ \\ \\ \\ \\ \\ \\ \\ u0026lt; tr valign = "top"> "
Response.Write "\\ \\ \\ \\ \\ \\ \\ \\ u0026lt; td align =" right "> Post Code: \\ \\ \\ \\ \\ \\ \\ \\ u0026lt; / td>"
Response.Write "\\ \\ \\ \\ \\ \\ \\ \\ u0026lt; td> \\ \\ \\ \\ \\ \\ \\ \\ u0026lt; input type = 'text' size = '10 'name =' value zip '='" & & strZip " '\\ \\ \\ \\ \\ \\ \\ \\ u0026lt; / input> \\ \\ \\ \\ \\ \\ \\ \\ u0026lt; / td> "
Response.Write "\\ \\ \\ \\ \\ \\ \\ \\ u0026lt; / tr> \\ \\ \\ \\ \\ \\ \\ \\ u0026lt; tr valign =" top ">"
Response.Write "\\ \\ \\ \\ \\ \\ \\ \\ u0026lt; colspan td align =" right "=" 2 ">"
U0026lt Response.Write "\\ \\ \\ \\ \\ \\ \\ \\; input type =" submit "value =" Submit ">"
Response.Write "\\ \\ \\ \\ \\ \\ \\ \\ u0026lt; /> \\ \\ \\ \\ \\ \\ \\ \\ u0026lt; / tr> \\ \\ \\ \\ \\ \\ \\ \\ u0026lt; / table> \\ \\ \\ \\ \\ \\ \\ \\ u0026lt; / form> td "
Other
Do Your Stuff from the database
End If
Post a Comment