SELECT 로 Query문 만들기

SELECT 'UPDATE HCTB_CHK_STMT SET HOSPITAL_CD = '''||HOSPITAL_CD ||''' WHERE ENP_NO = '''|| FAMILY_NO || ''' AND CHK_YEAR=''2010'' ' 
FROM HCTB_EXECUTIVE_CHECKUP_DETAIL
WHERE FAMILY_SEQ ='0'
AND HOSPITAL_CD IS NOT NULL