SQL> select * from county_code; CO COUNTY MIN_EAST MAX_EAST MIN_NORTH -- ---------------------------------------- ---------- ---------- ---------- MAX_NORTH ---------- AV Avon (former county of) BD Bedfordshire BK Berkshire (former county of) BU Buckinghamshire CB Cambridgeshire CH Cheshire CI Channel Islands CL Cleveland (former county of) CO Cornwall CU Cumbria DO Dorset DR Derbyshire DU Durham DV Devon ES East Sussex EX Essex GC Gloucestershire GM Greater Manchester HA Hampshire HT Hertfordshire HU Humberside (former county of) HW Hereford and Worcester (former county) IM Isle of Man IW Isle of Wight KE Kent LA Lancashire LE Leicestershire LI Lincolnshire LO Greater London MR Merseyside ND Northumberland NF Norfolk CO COUNTY MIN_EAST MAX_EAST MIN_NORTH -- ---------------------------------------- ---------- ---------- ---------- MAX_NORTH ---------- NN Northamptonshire NT Nottinghamshire NY North Yorkshire OX Oxfordshire SA Shropshire SF Suffolk SI Isles of Scilly SO Somerset ST Staffordshire SU Surrey SY South Yorkshire TW Tyne and Wear WA Warwickshire WI Wiltshire WM West Midlands WS West Sussex WY West Yorkshire WL Wales SC Scotland WC Worcestershire 52 rows selected. SQL> spool off