SQL> select * from solid_geology; CODE DESCRIPTION ------ ------------------------------------------------------------ 96 CORNBRASH 97 OXFORD CLAY AND KELLAWAYS BEDS 106 CHALK (INCLUDING RED CHALK) 109 BARTON, BRACKLESHAM AND BAGSHOT BEDS 76 LOWER DEVONIAN 98 CORALLIAN 99 KIMMERIDGE CLAY 75 LOWER OLD RED SANDSTONE (INCLUDING DOWNTONIAN) 91 LOWER LIAS 92 MIDDLE LIAS 93 UPPER LIAS 94 INFERIOR OOLITE 95 GREAT OOLITE 100 PORTLAND BEDS 101 PURBECK BEDS 89 PERMIAN AND TRIASSIC SANDSTONES - UNDIFFERENTIATED 108 LONDON CLAY 83 UPPER WESTPHALIAN (C+D) 115 NORWICH CRAG, RED CRAG AND CHILLESFORD CLAY 81 NAMURIAN ("MILLSTONE GRIT SERIES") 90 TRIASSIC MUDSTONES 80 TOURNAISIAN AND VISEAN ("CARBONIFEROUS LIMESTONE SERIES") 82 LOWER WESTPHALIAN (A+B) 105 UPPER GREENSAND AND GAULT 104 LOWER GREENSAND 86 MAGNESIAN LIMESTONE 78 UPPER DEVONIAN AND UPPER OLD RED SANDSTONE 79 BASAL CONGLOMERATE 34 GRANITE, SYENITE, GRANOPHYRE AND ALLIED TYPES 85 PERMIAN BASAL BRECCIAS, SANDSTONES AND MUDSTONES 111 HAMSTEAD BEDS AND BEMBRIDGE MARLS 102 HASTINGS BEDS 103 WEALD CLAY 107 OLDHAVEN, BLACKHEATH, WOOLWICH AND READING AND THANET BEDS 84 WESTPHALIAN AND ? STEPHANIAN, UNDIVIDED OF "BARREN RED" 71 ASHGILL 70 CARADOC 31 ULTRABASIC ROCK 32 GABBRO AND ALLIED TYPES 75-8 DEVONIAN UNDIFFERENTIATED 81-3 UPPER CARBONIFEROUS UNDIFFERENTIATED 77 MIDDLE DEVONIAN (ENGLAND) 70-71 ASHGILL AND CARADOC UNDIFFERENTIATED 72 LLANDOVERY 30 GNEISS, MICA SCHIST 102-5 LOWER CRETACEOUS - UNDIFFERENTIATED 77-8 MIDDLE/UPPER DEVONIAN UNDIFFERENTIATED 37 RHYOLITE, TRACHYTE, FELSITE, ELVANS, AND ALLIED TYPES 61 TORRIDONIAN SANDSTONE AND GRIT 74 LUDLOW 82-3 WESTPHALIAN 94-5 OOLITE - UNDIFFERENTIATED 98-9 AMPTHILL AND KIMMERIDGE CLAY 1 UNDIFFERENTIATED GNEISS OF THE LEWISIAN COMPLEX 60 PRECAMBRIAN 110 BOVEY FORMATION, ST AGNES SANDS, ETC. 112 LENHAM BEDS 113 CORALLINE BEDS 114 ST ERTH BEDS (CORNWALL) 66 UPPER CAMBRIAN, INCLUDING TREMADOC 65 MIDDLE CAMBRIAN 64 LOWER CAMBRIAN 64-6 CAMBRIAN 73 WENLOCK 87 PERMIAN MUDSTONES 88 BUDLEIGH SALTERTON PEBBLE BEDS 69 LLANDEILO 68 LLANVIRN AND ARENIG 35 BASALT, DOLERITE, CAMPTONITE AND ALLIED TYPES 78-80 CARBONIFEROUS/DEVONIAN TRANSITION GROUP 50 DEVONIAN ANDESITIC AND BASALTIC LAVAS AND TUFFS, UNDIFF. 71 rows selected. SQL> spool survey_type