I have one table in which there is one field called info.This field hold json value. I want to create trigger on this field.I want to split this json format string into record I mean I want to insert new record based on this json field.Is this thing possible?


jsonfield :{"part_req":{"p_id":"111","category":"stock","order_no":"23001"}}

I want to save this field 's value in product table

Output Should be :
Table : product

p_id -> 111
category -> stock
order_no -> 23001

is this things possible through trigger ???

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.