Query to remove HTML Tags from Rich Text Long edit box

Below query used to remove HTML tags from Rich text box field.

SELECT REGEXP_REPLACE(DESCRLONG,'<[^>]*>',' '), DESCRLONG FROM PS_HRSTOR_QA_TBL;

Note: Above query only works on Oracle database.