Midsummer Midsomer Murder SQL Challenge

View All Public Scripts Login to Run Script

Script Name Midsummer Midsomer Murder SQL Challenge
Visibility Unlisted - anyone with the share link can access
Description Setting up table and data for the Midsummer Midsomer Murder SQL Challenge. It's a challenge to win a signed copy of Kim Berg Hansen's book Practical Oracle SQL. Read details about the competition in this blog post: https://www.kibeha.dk/2020/06/midsummer-midsomer-murder-sql-challenge.html (Original data for the XML has been copied from https://midsomermurders.fandom.com/wiki/Midsomer_Body_Count )
Contributor Kim Berg Hansen
Created Tuesday June 09, 2020

Statement 1

Creating the table to store one row with the XML data in a CLOB column.

create table midsomer_xml (  
   id        integer primary key  
 , the_xml   clob  
)

Table created.

Statement 2
Insert one row to get the LOB locator for the CLOB that will be filled in the next statement.
```
insert into midsomer_xml (id) values (1)
```
```
1 row(s) inserted.
```

Statement 3

Filling the CLOB with a large piece of XML, which is a somewhat modified HTML snippet of data.

declare 
   xml_clob  clob; 
begin 
   select the_xml 
   into xml_clob 
   from midsomer_xml 
   where id = 1; 
 
   xml_clob := xml_clob || q'[ 
<table> 
 
<tr> 
<td>Ep ID</td> 
<td>Title</td> 
<td>Murdered During Episode</td> 
<td>Murdered Prior to Episode</td> 
<td>Death by Suicide</td> 
<td>Accidental or Natural Death</td> 
<td>Attempted Murders or Suicides</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>0.1</td> 
<td>The Killings at Badger's Drift</td> 
<td>Emily Simpson|Dennis Rainbird|Iris Rainbird|Katherine Lacey</td> 
<td>Bella Trace</td> 
<td>Phyllis Cadell|Michael Lacey</td> 
<td>Mr. Lacey|Mrs. Lacey</td> 
<td></td> 
</tr> 
<tr> 
<td>1.1</td> 
<td>Written in Blood</td> 
<td>Gerald Hadleigh|Max Jennings</td> 
<td>Mr. Hanlon</td> 
<td></td> 
<td>Ralph Lyddiard|Honoria Lyddiard</td> 
<td>Amy Lyddiard</td> 
</tr> 
<tr> 
<td>1.2</td> 
<td>Death of a Hollow Man</td> 
<td>Agnes Gray|Esslyn Carmichael</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Doris Winstanley</td> 
</tr> 
<tr> 
<td>1.3</td> 
<td>Faithful unto Death</td> 
<td>Brenda Buckley|Alan Hollingsworth</td> 
<td></td> 
<td></td> 
<td>Simone's mother</td> 
<td></td> 
</tr> 
<tr> 
<td>1.4</td> 
<td>Death in Disguise</td> 
<td>Ian Craigie|Guy Gamelin</td> 
<td>Gaius Quintus</td> 
<td></td> 
<td>William Carter</td> 
<td>Tim Riley</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>2.1</td> 
<td>Death's Shadow</td> 
<td>Richard Bayly|David Whitely|Simon Fletcher</td> 
<td></td> 
<td>Rev. Stephen Wentworth</td> 
<td>Felix Bryce|Jennifer Bryce</td> 
<td></td> 
</tr> 
<tr> 
<td>2.2</td> 
<td>Strangler's Wood</td> 
<td>Carla Constanza|Dr. Ian Aycott|Anna Santarosa|Leonard Pike</td> 
<td>Eva Hoffman|Joan Chaplin|Judith Albiston</td> 
<td></td> 
<td></td> 
<td>David Merrill|John Merrill</td> 
</tr> 
<tr> 
<td>2.3</td> 
<td>Dead Man's Eleven</td> 
<td>Tara Cavendish|Charles Jennings</td> 
<td>Emily Beavis</td> 
<td></td> 
<td>Matthew Draper|Patricia Smith</td> 
<td>Robert Cavendish</td> 
</tr> 
<tr> 
<td>2.4</td> 
<td>Blood Will Out</td> 
<td>Hector Bridges|John Smith</td> 
<td>Catherine Hamilton</td> 
<td></td> 
<td>John Lampson</td> 
<td>Hector Bridges</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>3.1</td> 
<td>Death of a Stranger</td> 
<td>Michael Darrow|Ben Gurdie|Ron Pringle|Marcia Tranter</td> 
<td>Simon Tranter</td> 
<td>Grahame Tranter</td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>3.2</td> 
<td>Blue Herrings</td> 
<td>Celia Armstrong</td> 
<td></td> 
<td></td> 
<td>Mrs. Mortimer|Muriel Harrap|Madge Fielding</td> 
<td></td> 
</tr> 
<tr> 
<td>3.3</td> 
<td>Judgement Day</td> 
<td>Peter Drinkwater|Rosemary Furman|Samantha Johnstone|Bella Devere</td> 
<td>Mrs. Foster</td> 
<td></td> 
<td>Michael Weston|Ruth Weston</td> 
<td>Samantha Johnstone</td> 
</tr> 
<tr> 
<td>3.4</td> 
<td>Beyond the Grave</td> 
<td>Marcus Lowrie|James Tate</td> 
<td>Jonathan Lowrie</td> 
<td></td> 
<td>David MacKillop</td> 
<td></td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>4.1</td> 
<td>Garden of Death</td> 
<td>Felicity Inkpen-Thomas|Elspeth Inkpen-Thomas|Gerald Bennett</td> 
<td>Cynthia Bennett</td> 
<td></td> 
<td></td> 
<td>Naomi Inkpen|Augustus Deverell</td> 
</tr> 
<tr> 
<td>4.2</td> 
<td>Destroying Angel</td> 
<td>Gregory Chambers|Tristan Goodfellow|Kenneth Gooders|Suzanna Chambers</td> 
<td>Karl Wainwright</td> 
<td>Evelyn Pope</td> 
<td></td> 
<td>Julia Gooders|Clarice Opperman|Evelyn Pope</td> 
</tr> 
<tr> 
<td>4.3</td> 
<td>The Electric Vendetta</td> 
<td>Steve Ramsey|Lloyd Kirby</td> 
<td></td> 
<td></td> 
<td>Ronald Stokes|Eddie Field|Isabel Aubrey|Dave Ripert</td> 
<td>Christian Aubrey</td> 
</tr> 
<tr> 
<td>4.4</td> 
<td>Who Killed Cock Robin?</td> 
<td>Robin Wooliscroft|Mary Mohan</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Sean O'Connell</td> 
</tr> 
<tr> 
<td>4.5</td> 
<td>Dark Autumn</td> 
<td>Dave Cutler|Debbie Shortlands|Simon Reason|Owen August</td> 
<td></td> 
<td>Tammie, the mother of John Field</td> 
<td></td> 
<td>WPC Jay Nash</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>5.1</td> 
<td>Tainted Fruit</td> 
<td>Melissa Townsend|Adam Keyne|Raif Canning</td> 
<td></td> 
<td></td> 
<td>Neil Laxton</td> 
<td></td> 
</tr> 
<tr> 
<td>5.2</td> 
<td>Market for Murder</td> 
<td>Marjorie Empson|Ginny Sharp|Lady Lavinia Chetwood</td> 
<td></td> 
<td></td> 
<td>Gerald Empson</td> 
<td>Selwyn Proctor</td> 
</tr> 
<tr> 
<td>5.3</td> 
<td>A Worm in the Bud</td> 
<td>Susan Bartlett|James Harrington|Victoria Bartlett</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Jonah Bloxham</td> 
</tr> 
<tr> 
<td>5.4</td> 
<td>Ring Out Your Dead</td> 
<td>Greg Tutt|Emma Tysoe|Marcus Steadman</td> 
<td>Reverend Jonathan Ebbrell</td> 
<td></td> 
<td>Reggie Barton</td> 
<td>Peter Fogden|Liam Booker|Frances Le Bon</td> 
</tr> 
<tr> 
<td>5.5</td> 
<td>Murder on St. Malley's Day</td> 
<td>Archie Bellingham|Daniel Talbot|Dudley Carew</td> 
<td></td> 
<td></td> 
<td>Sir. Walter Talbot</td> 
<td>Sir. Anthony Talbot</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>6.1</td> 
<td>A Talent for Life</td> 
<td>Isobel Hewitt|Dr. Duncan Goff|Keith Scholey</td> 
<td></td> 
<td></td> 
<td>Kenneth Hewitt|Mrs. Scholey</td> 
<td></td> 
</tr> 
<tr> 
<td>6.2</td> 
<td>Death and Dreams</td> 
<td>Martin Wroath|Tony Parish|Gordon Leesmith</td> 
<td>Andy Moore</td> 
<td></td> 
<td></td> 
<td>DCI Tom Barnaby</td> 
</tr> 
<tr> 
<td>6.3</td> 
<td>Painted in Blood</td> 
<td>Ruth Fairfax</td> 
<td></td> 
<td></td> 
<td></td> 
<td>DS Gavin Troy|DCI Tom Barnaby|Colin Hawksley|Mrs. Partridge|Mr. Miller</td> 
</tr> 
<tr> 
<td>6.4</td> 
<td>A Tale of Two Hamlets</td> 
<td>Larry Smith|Frank Webster|Danny Pinchel</td> 
<td></td> 
<td>St John Smythe-Webster</td> 
<td>Ellis Bell|Elsie Pinchel</td> 
<td>Phil Harrison</td> 
</tr> 
<tr> 
<td>6.5</td> 
<td>Birds of Prey</td> 
<td>Julian Shepherd|Charles Edmonton|Eddie Darwin|George Hamilton</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Mallory Edmonton</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>7.1</td> 
<td>The Green Man</td> 
<td>Simon Mayfield|Steven Curtis|Lillian Webster</td> 
<td>Eric Edwards</td> 
<td></td> 
<td>Sir Jonathan Haslett|Lettie Edwards</td> 
<td></td> 
</tr> 
<tr> 
<td>7.2</td> 
<td>Bad Tidings</td> 
<td>Fiona Thompson|Dr. Charles Rust|Jacob Stokes</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Cully Barnaby</td> 
</tr> 
<tr> 
<td>7.3</td> 
<td>The Fisher King</td> 
<td>Gareth Heldman|David Heartley-Reade|Dr. James Lavery</td> 
<td>Roger Heldman</td> 
<td></td> 
<td></td> 
<td>Miriam Heartley-Reade</td> 
</tr> 
<tr> 
<td>7.4</td> 
<td>Sins of Commission</td> 
<td>Richard Rackham|Neville Williams|Jezebel Tripp</td> 
<td></td> 
<td></td> 
<td>Conor Maplin</td> 
<td>Camilla Crofton|Sam Callaghan</td> 
</tr> 
<tr> 
<td>7.5</td> 
<td>The Maid in Splendour</td> 
<td>Jamie Cruickshank|Stephen Bannerman</td> 
<td></td> 
<td></td> 
<td>Mr. Monday|Susan Bannerman|Michael Bannerman</td> 
<td>Michael Bannerman</td> 
</tr> 
<tr> 
<td>7.6</td> 
<td>The Straw Woman</td> 
<td>Alex Deakin|Jim Hale|Liz Francis</td> 
<td></td> 
<td></td> 
<td>Mrs. Cole</td> 
<td>Dr. John Cole|Alan Clifford|Agnes Waterhouse</td> 
</tr> 
<tr> 
<td>7.7</td> 
<td>Ghosts of Christmas Past</td> 
<td>Lydia Villiers|Jennifer Carter</td> 
<td></td> 
<td>Ferdy Villiers|Claire English</td> 
<td></td> 
<td>Lydia Villiers</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>8.1</td> 
<td>Things That Go Bump in the Night</td> 
<td>Patrick Pennyman|Elizabeth Key|John Whittle</td> 
<td></td> 
<td>David Key|Rosemary Key</td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>8.2</td> 
<td>Dead in the Water</td> 
<td>Guy Sweetman</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Sandra Tate</td> 
</tr> 
<tr> 
<td>8.3</td> 
<td>Orchis Fatalis</td> 
<td>Madeline Villiers|Henry Plummer|Munro Hilliard</td> 
<td></td> 
<td></td> 
<td></td> 
<td>DCI Tom Barnaby|DS Dan Scott|Margaret Winstanley</td> 
</tr> 
<tr> 
<td>8.4</td> 
<td>Bantling Boy</td> 
<td>Bruce Hartley|Dr. John Osgood|Trevor Machin|Joanna Craxton</td> 
<td></td> 
<td></td> 
<td>Colonel Hartley</td> 
<td>Peter Craxton</td> 
</tr> 
<tr> 
<td>8.5</td> 
<td>Second Sight</td> 
<td>John Ransom|Dr. Gregory Ransom|Max Ransom</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Little Mal Kirby</td> 
</tr> 
<tr> 
<td>8.6</td> 
<td>Hidden Depths</td> 
<td>Jack Wilmot|Otto Benham|Mike Spicer</td> 
<td></td> 
<td></td> 
<td></td> 
<td>DCI Tom Barnaby|DS Dan Scott|Antonia Wilmot</td> 
</tr> 
<tr> 
<td>8.7</td> 
<td>Sauce for the Goose</td> 
<td>Dexter Lockwood</td> 
<td></td> 
<td>Stanley Lockwood</td> 
<td>Maurice Plummer</td> 
<td></td> 
</tr> 
<tr> 
<td>8.8</td> 
<td>Midsomer Rhapsody</td> 
<td>Arthur Leggott|Owen Swinscoe|Harvey Crane</td> 
<td></td> 
<td></td> 
<td>Joan Alder</td> 
<td></td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>9.1</td> 
<td>The House in the Woods</td> 
<td>Caroline Cave|Peter Cave|Harriet Davis</td> 
<td>P.C. Colin Armstrong</td> 
<td></td> 
<td>Mr. Barrett|Mrs. Barrett</td> 
<td>Jack Magwood</td> 
</tr> 
<tr> 
<td>9.2</td> 
<td>Dead Letters</td> 
<td>Marion Slade|Mark Castle|Dr. Wellow</td> 
<td></td> 
<td></td> 
<td>Bella Slade</td> 
<td>Alistair Gooding</td> 
</tr> 
<tr> 
<td>9.3</td> 
<td>Vixen's Run</td> 
<td>Henry York|Lady Sandra Butler</td> 
<td></td> 
<td></td> 
<td>Sir Freddy Butler</td> 
<td></td> 
</tr> 
<tr> 
<td>9.4</td> 
<td>Down Among the Dead Men</td> 
<td>Martin Barrett</td> 
<td></td> 
<td></td> 
<td>Jean Waverley</td> 
<td>Sir John Waverley</td> 
</tr> 
<tr> 
<td>9.5</td> 
<td>Four Funerals and a Wedding</td> 
<td>Mildred Danvers|Rev. Anthony Gant|Cathy Hewlett</td> 
<td></td> 
<td>Vivienne Marwood</td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>9.6</td> 
<td>Country Matters</td> 
<td>Frank Hopkirk</td> 
<td></td> 
<td></td> 
<td>Giles Southerly</td> 
<td></td> 
</tr> 
<tr> 
<td>9.7</td> 
<td>Death in Chorus</td> 
<td>Connor Simpson|Sam Judd</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Carolyn Armitage</td> 
</tr> 
<tr> 
<td>9.8</td> 
<td>Last Year's Model</td> 
<td></td> 
<td>Frances Trevelyan</td> 
<td></td> 
<td></td> 
<td>Mrs. Beverley</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>10.1</td> 
<td>Dance with the Dead</td> 
<td>Simon Bright|Laura Sharp|Tony Kirby</td> 
<td></td> 
<td></td> 
<td>Ralph Wood</td> 
<td>Carol Prentice</td> 
</tr> 
<tr> 
<td>10.2</td> 
<td>The Animal Within</td> 
<td>Rex Masters|Miles King|Eileen Carnack</td> 
<td></td> 
<td></td> 
<td>Lucinda Thacker</td> 
<td></td> 
</tr> 
<tr> 
<td>10.3</td> 
<td>King's Crystal</td> 
<td>Alan King|Ian King</td> 
<td></td> 
<td>Peter Baxter</td> 
<td></td> 
<td>Ian King|Charles King</td> 
</tr> 
<tr> 
<td>10.4</td> 
<td>The Axeman Cometh</td> 
<td>Mimi Clifton|Nicky Harding</td> 
<td></td> 
<td>Ginger Foxton</td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>10.5</td> 
<td>Death and Dust</td> 
<td>Dr. Alan Delaney</td> 
<td></td> 
<td>Sarah Kirkwood</td> 
<td></td> 
<td>Dr. James Kirkwood</td> 
</tr> 
<tr> 
<td>10.6</td> 
<td>Picture of Innocence</td> 
<td>Lionel Bell|Steve Bright</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Martin Spellman</td> 
</tr> 
<tr> 
<td>10.7</td> 
<td>They Seek Him Here</td> 
<td>Nick Cheyney|Gwen Morrison</td> 
<td></td> 
<td></td> 
<td>Ted Hayward</td> 
<td>Neville Hayward</td> 
</tr> 
<tr> 
<td>10.8</td> 
<td>Death in a Chocolate Box</td> 
<td>Jack Colby|Eddie Marston</td> 
<td>Maria Godbold</td> 
<td>Gina Colby</td> 
<td></td> 
<td></td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>11.1</td> 
<td>Shot at Dawn</td> 
<td>Henry Hammond|Johnny Hammond</td> 
<td>Tommy Hicks</td> 
<td></td> 
<td>Duggie Hammond</td> 
<td>Arabella Hammond</td> 
</tr> 
<tr> 
<td>11.2</td> 
<td>Blood Wedding</td> 
<td>Marina Fellowes|Robin Lawson|Peggy Benson</td> 
<td></td> 
<td></td> 
<td>Lady Fitzroy|Lord Fitzroy</td> 
<td>DCI Tom Barnaby|Ned Fitzroy|DS Ben Jones</td> 
</tr> 
<tr> 
<td>11.3</td> 
<td>Left for Dead</td> 
<td>Ron Wilson|Jack Purdy|Louise Purdy</td> 
<td></td> 
<td>Mr. Purdy</td> 
<td>Libby Wilson|Michael Wilson</td> 
<td>Patrick Bradley|Charlotte Knight</td> 
</tr> 
<tr> 
<td>11.4</td> 
<td>Midsomer Life</td> 
<td>Frederick Tomlin|Guy Sandys|Eleanor Crouch</td> 
<td></td> 
<td></td> 
<td>Mrs. Wilson's Sister|Charlie Finleyson</td> 
<td></td> 
</tr> 
<tr> 
<td>11.5</td> 
<td>The Magician's Nephew</td> 
<td>Jean Wildacre|Hugo Cartwright|Aloysius Wilmington</td> 
<td></td> 
<td></td> 
<td>Lucy Wilmington|Tristan Balliol</td> 
<td>Ernest Balliol</td> 
</tr> 
<tr> 
<td>11.6</td> 
<td>Days of Misrule</td> 
<td>Alec Grainger|James Parkes</td> 
<td></td> 
<td>Gilly Galsworthy</td> 
<td>Colonel Halsey|Mrs. Parkes</td> 
<td></td> 
</tr> 
<tr> 
<td>11.7</td> 
<td>Talking to the Dead</td> 
<td>Terrance Lowther|Colin Thomas|Molly Thomas|Lynton Pargeter</td> 
<td></td> 
<td></td> 
<td>Peter Thomas|Cyrus LeVanu</td> 
<td>Nesta Goodfellow|Stanley Goodfellow</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>12.1</td> 
<td>The Dogleg Murders</td> 
<td>Alistair Kingslake|Ed Monkberry</td> 
<td></td> 
<td></td> 
<td>Grandfather Crisp|Mr. Crisp|Mr. Fountain</td> 
<td>Miles Tully</td> 
</tr> 
<tr> 
<td>12.2</td> 
<td>The Black Book</td> 
<td>Felicity Law|Graham Spate|Anthony Prideaux</td> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>12.3</td> 
<td>Secrets and Spies</td> 
<td>Geoffrey Larkin|Nicky Frazer</td> 
<td></td> 
<td></td> 
<td>Gwendoline Frazer</td> 
<td>Malcolm Frazer</td> 
</tr> 
<tr> 
<td>12.4</td> 
<td>The Glitch</td> 
<td>Emily Harte|Daniel Snape</td> 
<td></td> 
<td></td> 
<td></td> 
<td>George Jeffers</td> 
</tr> 
<tr> 
<td>12.5</td> 
<td>Small Mercies</td> 
<td>Richard Tanner|Christa Palfrey|Harriet Compton</td> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>12.6</td> 
<td>The Creeper</td> 
<td>David Roper|Dr. Sylvia Goring</td> 
<td></td> 
<td></td> 
<td>Harry Godbolt</td> 
<td>Elizabeth Chettham</td> 
</tr> 
<tr> 
<td>12.7</td> 
<td>The Great and the Good</td> 
<td>Jim Hanley|Laurence Mann</td> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>13.1</td> 
<td>The Made-to-Measure Murders</td> 
<td>Sonia Woodley|Reverend Archie Moreland</td> 
<td>An unnamed gardener</td> 
<td></td> 
<td>Gerald Woodley</td> 
<td>Katie Soper</td> 
</tr> 
<tr> 
<td>13.2</td> 
<td>The Sword of Guillaume</td> 
<td>Hugh Dalgleish|Jenny Russell</td> 
<td></td> 
<td></td> 
<td>Sir Richard Guillaume</td> 
<td>Giles Shawcross|DCI Tom Barnaby</td> 
</tr> 
<tr> 
<td>13.3</td> 
<td>Blood on the Saddle</td> 
<td>Faye Lennox|Jack Fincher|Leo Fincher|Fergal Jenner</td> 
<td></td> 
<td></td> 
<td>Caleb Burbage|Noah Fincher|David Langham</td> 
<td>Susan Fincher|Jude Langham|DCI Tom Barnaby|DS Ben Jones</td> 
</tr> 
<tr> 
<td>13.4</td> 
<td>The Silent Land</td> 
<td>Gerald Ebbs|Jeff Bowmaker</td> 
<td>Landlord's wife|Landlord's daughter</td> 
<td>Caroline Maria Roberts|An unnamed landlord</td> 
<td>The patients from Saint Fidelis Hospital|Mrs. Peach</td> 
<td></td> 
</tr> 
<tr> 
<td>13.5</td> 
<td>Master Class</td> 
<td>Orlando Guest|Reverend Connor Gregory</td> 
<td></td> 
<td>Molly Fielding</td> 
<td></td> 
<td>DCI Tom Barnaby|Terry Stock|Dawn Stock</td> 
</tr> 
<tr> 
<td>13.6</td> 
<td>The Noble Art</td> 
<td>Giles Braithwaite|Frank Bishop|Iris Holman</td> 
<td></td> 
<td></td> 
<td>Sebastian's Biological Father</td> 
<td></td> 
</tr> 
<tr> 
<td>13.7</td> 
<td>Not in My Back Yard</td> 
<td>Maureen Stubbs|Clifford Bunting|Geoff Rogers</td> 
<td></td> 
<td></td> 
<td>Mr. Conway|Douglas Stubbs</td> 
<td>Norman Swanscombe|DCI Tom Barnaby</td> 
</tr> 
<tr> 
<td>13.8</td> 
<td>Fit For Murder</td> 
<td>Kitty Pottinger|Luke Archbold|The vicar at Badger's Drift</td> 
<td></td> 
<td></td> 
<td><b>Mr. Barnaby</b>|Magnus</td> 
<td>Kenny Pottinger</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>14.1</td> 
<td>Death in the Slow Lane</td> 
<td>Dave Doggy Day|Thomas Brightwell</td> 
<td>Duncan Palmer</td> 
<td></td> 
<td></td> 
<td>DCI John Barnaby</td> 
</tr> 
<tr> 
<td>14.2</td> 
<td>Dark Secrets</td> 
<td>Gerry Dawkins|Mary Bingham</td> 
<td></td> 
<td></td> 
<td>Bertie Morell|Robin Bingham|Dr. Jonathan Frost</td> 
<td>William Bingham|DCI John Barnaby|DS Ben Jones</td> 
</tr> 
<tr> 
<td>14.3</td> 
<td>Echoes of the Dead</td> 
<td>Dianne Price|Fran Carter|Len Merryman|Olive Merryman</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Jo Starling</td> 
</tr> 
<tr> 
<td>14.4</td> 
<td>The Oblong Murders</td> 
<td>Freddie Raft</td> 
<td>Jeremy Lambert|Carolyn Lambert|Max Fuller</td> 
<td></td> 
<td></td> 
<td>Claire Powell|Paddy Powell|DCI John Barnaby|DS Ben Jones</td> 
</tr> 
<tr> 
<td>14.5</td> 
<td>The Sleeper Under the Hill</td> 
<td>Alex Preston|Leticia Clifford|Sgt. Trevor Gibson</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Ezra Canning</td> 
</tr> 
<tr> 
<td>14.6</td> 
<td>The Night of the Stag</td> 
<td>Peter Slim|Conrad Walker</td> 
<td></td> 
<td></td> 
<td></td> 
<td>DCI John Barnaby|DS Ben Jones|Byron Street|Silas Trout</td> 
</tr> 
<tr> 
<td>14.7</td> 
<td>A Sacred Trust</td> 
<td>Mother Thomas|Father Behan</td> 
<td></td> 
<td></td> 
<td>Sir Anthony Vertue|Mr. Vertue</td> 
<td>Mother Julian</td> 
</tr> 
<tr> 
<td>14.8</td> 
<td>A Rare Bird</td> 
<td>Patrick Morgan|Dr. Markham</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Nina Morgan</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>15.1</td> 
<td>The Dark Rider</td> 
<td>Julian DeQuetteville|Ludo DeQuetteville</td> 
<td>Geoffrey DeQuetteville</td> 
<td></td> 
<td>Rupert DeQuetteville|Angela DeQuetteville|Bentham DeQuetteville</td> 
<td>Sasha Fleetwood</td> 
</tr> 
<tr> 
<td>15.2</td> 
<td>Murder of Innocence</td> 
<td>Giles Harrison|Caroline Garrett|Kyle Gideon|Keith Mulory</td> 
<td>Daniel Denning|Mrs. Mulory</td> 
<td></td> 
<td>Miss Felton|Ross</td> 
<td>Keith Mulory|DS Ben Jones|Ted Denning|Grady Felton|DCI John Barnaby</td> 
</tr> 
<tr> 
<td>15.3</td> 
<td>Written in the Stars</td> 
<td>Jeremy Harper|Peter Groves|George Dormer</td> 
<td></td> 
<td></td> 
<td>Tom Stanton|Mary Dutta</td> 
<td>Gagan Dutta</td> 
</tr> 
<tr> 
<td>15.4</td> 
<td>Death and the Divas</td> 
<td>Eve Lomax|Cy Davenport|Colin Yule</td> 
<td></td> 
<td></td> 
<td>George William Tilman|Felicity Mary|Michael Harris</td> 
<td>Diana Davenport</td> 
</tr> 
<tr> 
<td>15.5</td> 
<td>The Sicilian Defence</td> 
<td>Edward Stannington|David Farmer</td> 
<td></td> 
<td>Jason Winters</td> 
<td>Reverend Stannington|Vladimir Kostelov|Marion Green|Jack Barton</td> 
<td>Finn Robson</td> 
</tr> 
<tr> 
<td>15.6</td> 
<td>Schooled in Murder</td> 
<td>Debbie Moffett|Oliver Ordish|Gregory Brantner|Helen Caxton</td> 
<td></td> 
<td>Phil Caxton</td> 
<td>Lady Elizabeth Rodney|Jim Caxton</td> 
<td>Beatrix Ordish|Sylvia Mountford</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>16.1</td> 
<td>The Christmas Haunting</td> 
<td>Conor Bridgeman|Ross Clymer</td> 
<td></td> 
<td></td> 
<td>Little Rose Wilton|Mr. Fergus-Johnson</td> 
<td>Ollie Tabori</td> 
</tr> 
<tr> 
<td>16.2</td> 
<td>Let Us Prey</td> 
<td>Nancy Dewar|Frank Dewar|Philip Hamilton</td> 
<td></td> 
<td></td> 
<td>Tina Bell</td> 
<td></td> 
</tr> 
<tr> 
<td>16.3</td> 
<td>Wild Harvest</td> 
<td>Martin Strickland|Amy Strickland</td> 
<td></td> 
<td></td> 
<td>Max Thornfield</td> 
<td>Nick's Stepfather|Ruth Cameron|Johnny Linklater</td> 
</tr> 
<tr> 
<td>16.4</td> 
<td>The Flying Club</td> 
<td>Bernard King|Eddie Rayner</td> 
<td></td> 
<td>Ellie Wingate</td> 
<td>Henry Darnley|Joan Rayner</td> 
<td>Gavin Hopkirk</td> 
</tr> 
<tr> 
<td>16.5</td> 
<td>The Killings of Copenhagen</td> 
<td>Eric Calder|Julian Calder|Ernest Bradley|Atticus Bradley</td> 
<td></td> 
<td></td> 
<td>Agnes Trout</td> 
<td>Armand Stone</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>17.1</td> 
<td>The Dagger Club</td> 
<td>Suzie Colebrooke|Cecilie Petersen|Niall Colebrooke|George Summersbee</td> 
<td></td> 
<td></td> 
<td>Mark Sampson</td> 
<td></td> 
</tr> 
<tr> 
<td>17.2</td> 
<td>Murder by Magic</td> 
<td>Hannah Altman|Andrew Maplin|Annabel Latimer</td> 
<td>Sir Hugo Melmoth</td> 
<td></td> 
<td>Enrico Latimer|William Holt</td> 
<td>Luke Altman</td> 
</tr> 
<tr> 
<td>17.3</td> 
<td>The Ballad of Midsomer County</td> 
<td>Toby Winning|Brian Grey|Frank Wainwright</td> 
<td>Johnny Carver</td> 
<td></td> 
<td></td> 
<td>Claire Asher|DCI John Barnaby|DS Charlie Nelson</td> 
</tr> 
<tr> 
<td>17.4</td> 
<td>A Vintage Murder</td> 
<td>Nadia Simons|Louis Paynton</td> 
<td>Jessica Tyler</td> 
<td></td> 
<td>Mr. Stowe</td> 
<td>Tina Tyler</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>18.1</td> 
<td>Habeas Corpus</td> 
<td></td> 
<td></td> 
<td>Richard Melrose</td> 
<td>Lydia Dryffield|Gregory Lancaster</td> 
<td>Felix Lancaster</td> 
</tr> 
<tr> 
<td>18.2</td> 
<td>The Incident at Cooper Hill</td> 
<td>Felicity Ford|Yasmin Ali|Carter Faulkner</td> 
<td>Eric Tonev</td> 
<td></td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>18.3</td> 
<td>Breaking the Chain</td> 
<td>Greg Eddon|Aiden McCordell</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Des McCordell</td> 
</tr> 
<tr> 
<td>18.4</td> 
<td>A Dying Art</td> 
<td>Brandon Monkford|Tony Pitt|Lance Auden</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Daniel Fargo</td> 
</tr> 
<tr> 
<td>18.5</td> 
<td>Saints and Sinners</td> 
<td>Zoe Dyer|Alex Dyer|Christopher Corby</td> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>18.6</td> 
<td>Harvest of Souls</td> 
<td>Harry Wyham|Clara Myerscough|Dale Nevins</td> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>19.1</td> 
<td>The Village That Rose from the Dead</td> 
<td>Finn Thornberry|Roderick Craven|Milo Craven</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Julian Lennard</td> 
</tr> 
<tr> 
<td>19.2</td> 
<td>Crime and Punishment</td> 
<td>Angus Colton|Azeem Meer</td> 
<td>Frank Lockston</td> 
<td></td> 
<td></td> 
<td>Barbara Walton</td> 
</tr> 
<tr> 
<td>19.3</td> 
<td>Last Man Out</td> 
<td>Leo Henderson|Fitz Theara</td> 
<td></td> 
<td></td> 
<td></td> 
<td>DI Ben Jones</td> 
</tr> 
<tr> 
<td>19.4</td> 
<td>Red in Tooth &amp; Claw</td> 
<td>Seb Huntington|Cleo Langton</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Errol Judd</td> 
</tr> 
<tr> 
<td>19.5</td> 
<td>Death by Persuasion</td> 
<td>Samantha Berry|Ronin Chow</td> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>19.6</td> 
<td>The Curse of the Ninth</td> 
<td>Jacob Wheeler|Vernon De Harthog</td> 
<td>The real Jacob Wheeler</td> 
<td></td> 
<td></td> 
<td>Natalie Wheeler</td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>20.1</td> 
<td>The Ghost of Causton Abbey</td> 
<td>Adam Osoba|Emani Taylor</td> 
<td>Brother Jozef</td> 
<td></td> 
<td>Jenny Moss</td> 
<td></td> 
</tr> 
<tr> 
<td>20.2</td> 
<td>Death of the Small Coppers</td> 
<td>Mahesh Sidana|Grady Palmerston</td> 
<td></td> 
<td></td> 
<td>Jane Scott</td> 
<td>DS Jamie Winter</td> 
</tr> 
<tr> 
<td>20.3</td> 
<td>Drawing Dead</td> 
<td>Francesca Lounds|Barrett Lounds</td> 
<td>Conrad Argo</td> 
<td></td> 
<td></td> 
<td>Stella Starling</td> 
</tr> 
<tr> 
<td>20.4</td> 
<td>The Lions of Causton</td> 
<td>Mark Adler|Dominic Braun</td> 
<td></td> 
<td>Neville Gallagher</td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>20.5</td> 
<td>Till Death Do Us Part</td> 
<td>Laurel Newman|Serena Madison|Aisha Khalique</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Sarah Barnaby</td> 
</tr> 
<tr> 
<td>20.6</td> 
<td>Send in the Clowns</td> 
<td>Terry Bellini|Ashley Denton</td> 
<td></td> 
<td></td> 
<td>Curtis Ferabbee</td> 
<td></td> 
</tr> 
]'; 
 
   xml_clob := xml_clob || q'[ 
<tr> 
<td>21.1</td> 
<td>The Point of Balance</td> 
<td>Rosa Corrigan|Duncan Corrigan</td> 
<td></td> 
<td></td> 
<td></td> 
<td></td> 
</tr> 
<tr> 
<td>21.2</td> 
<td>The Miniature Murders</td> 
<td>Alexander Beauvoisin|Jemima Starling</td> 
<td>Nico Dearden</td> 
<td></td> 
<td>Lara Wokoma</td> 
<td></td> 
</tr> 
<tr> 
<td>21.3</td> 
<td>The Sting of Death</td> 
<td>Dr. Serena Lowe|Cal Ingalls</td> 
<td></td> 
<td></td> 
<td></td> 
<td>Cal Ingalls|Ambrose Deddington</td> 
</tr> 
<tr> 
<td>21.4</td> 
<td>With Baited Breath</td> 
<td>Lex Bedford|Eric Skye|Cornelius Tetbury</td> 
<td></td> 
<td></td> 
<td>Lola Silvermane</td> 
<td>Griffon Twigg|Blaise McQuinn|Artie Blythe</td> 
</tr> 
 
</table> 
]'; 
 
   update midsomer_xml 
   set the_xml = xml_clob 
   where id = 1; 
    
   commit; 
end;

Statement processed.

Statement 4

Confirm that the XML in the CLOB can be converted to XMLTYPE and therefore is valid XML.

select  
   substr(xmlserialize(document xmltype(the_xml) indent), 1, 4000) as xml_start  
from midsomer_xml  
where id = 1


XML_START
<table>
  <tr>
    <td>Ep ID</td>
    <td>Title</td>
    <td>Murdered During Episode</td>
    <td>Murdered Prior to Episode</td>
    <td>Death by Suicide</td>
    <td>Accidental or Natural Death</td>
    <td>Attempted Murders or Suicides</td>
  </tr>
  <tr>
    <td>0.1</td>
    <td>The Killings at Badger&apos;s Drift</td>
    <td>Emily Simpson|Dennis Rainbird|Iris Rainbird|Katherine Lacey</td>
    <td>Bella Trace</td>
    <td>Phyllis Cadell|Michael Lacey</td>
    <td>Mr. Lacey|Mrs. Lacey</td>
    <td/>
  </tr>
  <tr>
    <td>1.1</td>
    <td>Written in Blood</td>
    <td>Gerald Hadleigh|Max Jennings</td>
    <td>Mr. Hanlon</td>
    <td/>
    <td>Ralph Lyddiard|Honoria Lyddiard</td>
    <td>Amy Lyddiard</td>
  </tr>
  <tr>
    <td>1.2</td>
    <td>Death of a Hollow Man</td>
    <td>Agnes Gray|Esslyn Carmichael</td>
    <td/>
    <td/>
    <td/>
    <td>Doris Winstanley</td>
  </tr>
  <tr>
    <td>1.3</td>
    <td>Faithful unto Death</td>
    <td>Brenda Buckley|Alan Hollingsworth</td>
    <td/>
    <td/>
    <td>Simone&apos;s mother</td>
    <td/>
  </tr>
  <tr>
    <td>1.4</td>
    <td>Death in Disguise</td>
    <td>Ian Craigie|Guy Gamelin</td>
    <td>Gaius Quintus</td>
    <td/>
    <td>William Carter</td>
    <td>Tim Riley</td>
  </tr>
  <tr>
    <td>2.1</td>
    <td>Death&apos;s Shadow</td>
    <td>Richard Bayly|David Whitely|Simon Fletcher</td>
    <td/>
    <td>Rev. Stephen Wentworth</td>
    <td>Felix Bryce|Jennifer Bryce</td>
    <td/>
  </tr>
  <tr>
    <td>2.2</td>
    <td>Strangler&apos;s Wood</td>
    <td>Carla Constanza|Dr. Ian Aycott|Anna Santarosa|Leonard Pike</td>
    <td>Eva Hoffman|Joan Chaplin|Judith Albiston</td>
    <td/>
    <td/>
    <td>David Merrill|John Merrill</td>
  </tr>
  <tr>
    <td>2.3</td>
    <td>Dead Man&apos;s Eleven</td>
    <td>Tara Cavendish|Charles Jennings</td>
    <td>Emily Beavis</td>
    <td/>
    <td>Matthew Draper|Patricia Smith</td>
    <td>Robert Cavendish</td>
  </tr>
  <tr>
    <td>2.4</td>
    <td>Blood Will Out</td>
    <td>Hector Bridges|John Smith</td>
    <td>Catherine Hamilton</td>
    <td/>
    <td>John Lampson</td>
    <td>Hector Bridges</td>
  </tr>
  <tr>
    <td>3.1</td>
    <td>Death of a Stranger</td>
    <td>Michael Darrow|Ben Gurdie|Ron Pringle|Marcia Tranter</td>
    <td>Simon Tranter</td>
    <td>Grahame Tranter</td>
    <td/>
    <td/>
  </tr>
  <tr>
    <td>3.2</td>
    <td>Blue Herrings</td>
    <td>Celia Armstrong</td>
    <td/>
    <td/>
    <td>Mrs. Mortimer|Muriel Harrap|Madge Fielding</td>
    <td/>
  </tr>
  <tr>
    <td>3.3</td>
    <td>Judgement Day</td>
    <td>Peter Drinkwater|Rosemary Furman|Samantha Johnstone|Bella Devere</td>
    <td>Mrs. Foster</td>
    <td/>
    <td>Michael Weston|Ruth Weston</td>
    <td>Samantha Johnstone</td>
  </tr>
  <tr>
    <td>3.4</td>
    <td>Beyond the Grave</td>
    <td>Marcus Lowrie|James Tate</td>
    <td>Jonathan Lowrie</td>
    <td/>
    <td>David MacKillop</td>
    <td/>
  </tr>
  <tr>
    <td>4.1</td>
    <td>Garden of Death</td>
    <td>Felicity Inkpen-Thomas|Elspeth Inkpen-Thomas|Gerald Bennett</td>
    <td>Cynthia Bennett</td>
    <td/>
    <td/>
    <td>Naomi Inkpen|Augustus Deverell</td>
  </tr>
  <tr>
    <td>4.2</td>
    <td>Destroying Angel</td>
    <td>Gregory Chambers|Tristan Goodfellow|Kenneth Gooders|Suzanna Chambers</td>
    <td>Karl Wainwright</td>
    <td>Evelyn Pope</td>
    <td/>
    <td>Julia Gooders|Clarice Opperman|Evelyn Pope</td>
  </tr>
  <tr>
    <td>4.3</td>
    <td>The Electric Vendetta</td>
    <td>Steve Ramsey|Lloyd Kirby</td>
    <td/>
    <td/>
    <td>Ronald Stokes|Eddie Field|Isabel Aubrey|Dave Ripert</td>
    <td>Christian Aubrey</td>
  </tr>
  <tr>
    <td>4.4</td>
    <td>Who Killed Cock Robin?</td>
    <td>Robin Wooliscroft|Mary Mohan</td>
    <td/>
    <td/>
    <td/>
    <td>Sean O&apos;Connell</td>
  </tr>
  <tr>
    <td>4.5</td>
    <td>Dark Autumn</td>
    <td>Dave Cutler|Debbie Shortlands|Simon Reason|Owen August</td>
    <td/>
    <td>Tammie, the mother of John Field<

XML_START
<table> <tr> <td>Ep ID</td> <td>Title</td> <td>Murdered During Episode</td> <td>Murdered Prior to Episode</td> <td>Death by Suicide</td> <td>Accidental or Natural Death</td> <td>Attempted Murders or Suicides</td> </tr> <tr> <td>0.1</td> <td>The Killings at Badger's Drift</td> <td>Emily Simpson\|Dennis Rainbird\|Iris Rainbird\|Katherine Lacey</td> <td>Bella Trace</td> <td>Phyllis Cadell\|Michael Lacey</td> <td>Mr. Lacey\|Mrs. Lacey</td> <td/> </tr> <tr> <td>1.1</td> <td>Written in Blood</td> <td>Gerald Hadleigh\|Max Jennings</td> <td>Mr. Hanlon</td> <td/> <td>Ralph Lyddiard\|Honoria Lyddiard</td> <td>Amy Lyddiard</td> </tr> <tr> <td>1.2</td> <td>Death of a Hollow Man</td> <td>Agnes Gray\|Esslyn Carmichael</td> <td/> <td/> <td/> <td>Doris Winstanley</td> </tr> <tr> <td>1.3</td> <td>Faithful unto Death</td> <td>Brenda Buckley\|Alan Hollingsworth</td> <td/> <td/> <td>Simone's mother</td> <td/> </tr> <tr> <td>1.4</td> <td>Death in Disguise</td> <td>Ian Craigie\|Guy Gamelin</td> <td>Gaius Quintus</td> <td/> <td>William Carter</td> <td>Tim Riley</td> </tr> <tr> <td>2.1</td> <td>Death's Shadow</td> <td>Richard Bayly\|David Whitely\|Simon Fletcher</td> <td/> <td>Rev. Stephen Wentworth</td> <td>Felix Bryce\|Jennifer Bryce</td> <td/> </tr> <tr> <td>2.2</td> <td>Strangler's Wood</td> <td>Carla Constanza\|Dr. Ian Aycott\|Anna Santarosa\|Leonard Pike</td> <td>Eva Hoffman\|Joan Chaplin\|Judith Albiston</td> <td/> <td/> <td>David Merrill\|John Merrill</td> </tr> <tr> <td>2.3</td> <td>Dead Man's Eleven</td> <td>Tara Cavendish\|Charles Jennings</td> <td>Emily Beavis</td> <td/> <td>Matthew Draper\|Patricia Smith</td> <td>Robert Cavendish</td> </tr> <tr> <td>2.4</td> <td>Blood Will Out</td> <td>Hector Bridges\|John Smith</td> <td>Catherine Hamilton</td> <td/> <td>John Lampson</td> <td>Hector Bridges</td> </tr> <tr> <td>3.1</td> <td>Death of a Stranger</td> <td>Michael Darrow\|Ben Gurdie\|Ron Pringle\|Marcia Tranter</td> <td>Simon Tranter</td> <td>Grahame Tranter</td> <td/> <td/> </tr> <tr> <td>3.2</td> <td>Blue Herrings</td> <td>Celia Armstrong</td> <td/> <td/> <td>Mrs. Mortimer\|Muriel Harrap\|Madge Fielding</td> <td/> </tr> <tr> <td>3.3</td> <td>Judgement Day</td> <td>Peter Drinkwater\|Rosemary Furman\|Samantha Johnstone\|Bella Devere</td> <td>Mrs. Foster</td> <td/> <td>Michael Weston\|Ruth Weston</td> <td>Samantha Johnstone</td> </tr> <tr> <td>3.4</td> <td>Beyond the Grave</td> <td>Marcus Lowrie\|James Tate</td> <td>Jonathan Lowrie</td> <td/> <td>David MacKillop</td> <td/> </tr> <tr> <td>4.1</td> <td>Garden of Death</td> <td>Felicity Inkpen-Thomas\|Elspeth Inkpen-Thomas\|Gerald Bennett</td> <td>Cynthia Bennett</td> <td/> <td/> <td>Naomi Inkpen\|Augustus Deverell</td> </tr> <tr> <td>4.2</td> <td>Destroying Angel</td> <td>Gregory Chambers\|Tristan Goodfellow\|Kenneth Gooders\|Suzanna Chambers</td> <td>Karl Wainwright</td> <td>Evelyn Pope</td> <td/> <td>Julia Gooders\|Clarice Opperman\|Evelyn Pope</td> </tr> <tr> <td>4.3</td> <td>The Electric Vendetta</td> <td>Steve Ramsey\|Lloyd Kirby</td> <td/> <td/> <td>Ronald Stokes\|Eddie Field\|Isabel Aubrey\|Dave Ripert</td> <td>Christian Aubrey</td> </tr> <tr> <td>4.4</td> <td>Who Killed Cock Robin?</td> <td>Robin Wooliscroft\|Mary Mohan</td> <td/> <td/> <td/> <td>Sean O'Connell</td> </tr> <tr> <td>4.5</td> <td>Dark Autumn</td> <td>Dave Cutler\|Debbie Shortlands\|Simon Reason\|Owen August</td> <td/> <td>Tammie, the mother of John Field<

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database