SQL functions to extract data from a column
Posted on 2011-05-12
new'ish to SQL, so not sure if this is going to be possible at all!
Im using SQL Squirrel or SQL Developer to query some tables on my DB.
Ive got a table with a field with a "CLOB" type.
The data in the field is a load of HTML, eg:
<subject>New monkey generated</subject>
<html><body> blah blah
Questions: Is it possible to extract specific sections of this feild into new columns, eg.
could i run some SQL to give me all this information, each in their own column?
From | Subject | To |