December 9, 2011

Country / State Lookup Tables for Oracle

Filed under: Oracle — Tags: , , , — Darrin Maidlow @ 3:10 pm

The time has come for Country / State-Province lookup tables for Oracle!   Building on my earlier post on I’ve built a new script for Oracle.  This script will create two tables, two sequences for the primary keys, and two triggers to setup the auto-numbering.   Run the script and you should be good to go!

1 Comment »

  1. [...] **Update 2011.12.09 – I’ve posted an Oracle specific version of the Country/State/Province lookup SQL.  [...]

    Pingback by Country / State / Province Lookup Tables for SQL server « Geospecialling — December 9, 2011 @ 3:16 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress

Switch to our mobile site