Hi

i have table called t1

with column name offers with data as

"entitlementwrapper" : [ {

"Type" : "Factory Warranty",

"Date_Type" : "Ship date",

"Status" : "Active",

"Start_Date" : "2012-12-21",

"End_Date" : "2014-01-19",

"Days_Left" : "116",

"Term" : "13",

"Description" : "Wty: HP HW Replacement Support",

"IsTrusted" : "Y",

"Transaction_ID" : "4644780453"

},

i want to get data to store in other table

1.type

2.start_date

3.end_date

i need queery to load data into this table

thanks,

Pradeep