{"id":1273,"date":"2016-01-03T15:23:45","date_gmt":"2016-01-03T15:23:45","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1273"},"modified":"2016-01-03T15:23:45","modified_gmt":"2016-01-03T15:23:45","slug":"8-plsql-%ec%98%88%ec%99%b8%ec%b2%98%eb%a6%ac","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1273","title":{"rendered":"8. PL\/SQL \uc608\uc678\ucc98\ub9ac"},"content":{"rendered":"

8. PL\/SQL \uc608\uc678\ucc98\ub9ac<\/P>
\n

 <\/P>
\n

A. \uc608\uc678\ub780?<\/P>
\n

 <\/P>
\n

<\/P>
\n

– SELECT \ubb38\uc774 \ud589\uc744 \ud558\ub098\ub9cc \uc77d\uc5b4 \ub4e4\uc77c \uac83\uc73c\ub85c \uc608\uc0c1\ud588\uc9c0\ub9cc \uc5ec\ub7ec \ud589\uc744 \uc77d\uc5b4 \uc624\ub958 \ubc1c\uc0dd\ud558\uba70 \ube14\ub85d\uc774 \uc885\ub8cc\ub428<\/P>
\n

– \uc704\uc640\uac19\uc774 \ub7f0\ud0c0\uc784\uc5d0 \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\ub97c \uc608\uc678\ub77c\uace0 \ud55c\ub2e4.<\/P>
\n

ex)<\/P>
\n

declare<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_lname<\/SPAN> varchar2(15);<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>select <\/SPAN>last_name<\/SPAN> into <\/SPAN>v_lname<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>from employees<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>where <\/SPAN>first_name<\/SPAN>=\u2018John\u2019;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>dbms_output.put_line<\/SPAN> (\u2018<\/SPAN>John\u2019\u2019s<\/SPAN> last name is : \u2018 || <\/SPAN>v_lname<\/SPAN>);<\/SPAN><\/P>
\n

exception<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>when <\/SPAN>too_many_rows<\/SPAN> then<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>dbms_output.put_line<\/SPAN> (\u2018 Your select statement <\/SPAN>retrleved<\/SPAN> multiple rows. Consider using a cursor. \u2018);<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

 <\/P>
\n

B. PL\/SQL \uc608\uc678 \uc774\ud574<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uc608\uc678\ub294 \ud504\ub85c\uadf8\ub7a8 \uc2e4\ud589 \uc911\uc5d0 \ubc1c\uc0dd\ud55c <\/SPAN>PL\/SQL <\/SPAN>\uc624\ub958<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc608\uc678\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \ubc1c\uc0dd<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>Oracle <\/SPAN>\uc11c\ubc84\uc5d0\uc11c \ubb35\uc2dc\uc801\uc73c\ub85c \ubc1c\uc0dd<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud504\ub85c\uadf8\ub7a8\uc5d0 \uc758\ud574 \uba85\uc2dc\uc801\uc73c\ub85c \ubc1c\uc0dd<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc608\uc678\ub97c \ub2e4\uc74c\uacfc \uac19\uc774 \ucc98\ub9ac<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ucc98\ub9ac\uae30\ub85c \ud2b8\ub7a9<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud638\ucd9c \ud658\uacbd\uc73c\ub85c \uc804\ub2ec<\/SPAN><\/DIV>
\n
<\/DIV>
\n
<\/DIV>
\n

 <\/P>
\n

<\/P>
\n

C. \uc608\uc678 \uc720\ud615<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\ubb35\uc2dc\uc801\uc73c\ub85c \ubc1c\uc0dd<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ubbf8\ub9ac \uc815\uc758\ub41c <\/SPAN>Oracle <\/SPAN>\uc11c\ubc84 \uc624\ub958<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ubbf8\ub9ac \uc815\uc758\ub418\uc9c0 \uc54a\uc740 <\/SPAN>Oracle <\/SPAN>\uc11c\ubc84 \uc624\ub958<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uba85\uc2dc\uc801\uc73c\ub85c \ubc1c\uc0dd<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc0ac\uc6a9\uc790 \uc815\uc758<\/SPAN><\/DIV>
\n
<\/DIV>
\n

 <\/P>
\n

D. \uc608\uc678 \ud2b8\ub7a9<\/P>
\n

\u00a7<\/SPAN><\/SPAN>Syntax<\/SPAN><\/DIV>
\n

EXCEPTION<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>WHEN exception1 [OR exception2 \u2026] THEN<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>statement1;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>statement2;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>\u2026<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>[WHEN exception3 [OR exception4 \u2026] THEN<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>\u2026<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>[WHEN OTHERS THEN<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>statement1;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>statement2;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>\u2026]<\/SPAN>  <\/SPAN><\/SPAN><\/P>
\n

<\/DIV>
\n
<\/DIV>
\n

 <\/P>
\n

 E. \ubbf8\ub9ac \uc815\uc758\ub41c Oracle \uc11c\ubc84 \uc624\ub958<\/P><\/p>\n

 <\/p>\n

\u00a7<\/SPAN><\/SPAN>\ubbf8\ub9ac \uc815\uc758\ub41c \uc774\ub984\uc744 \ucc38\uc870<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>Sample<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>NO_DATA_FOUND<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>TOO_MANY_ROWS<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>INVALID_CURSOR<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>ZERO_DEVIDE<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>DUP_VAL_ON_INDEX<\/SPAN><\/DIV>
\n

 <\/P>
\n

<\/P>
\n

<\/P>
\n

<\/P>
\n

F. \ubbf8\ub9ac \uc815\uc758\ub418\uc9c0 \uc54a\uc740 Oracle \uc11c\ubc84 \uc624\ub958 \ud2b8\ub7a9<\/P>
\n

– \ubbf8\ub9ac \uc815\uc758\ub418\uc9c0 \uc54a\uc740 \uc608\uc678\ub294 \ud45c\uc900 Oracle \uc624\ub958.<\/P>
\n

– PRAGMA EXCEPTION_INIT \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud45c\uc900 Oracle \uc624\ub958\uac00 \uc788\ub294 \uc608\uc678\ub97c \uc0dd\uc131<\/P>
\n

ex)<\/P>
\n

declare<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>e_insert_excep<\/SPAN> EXCEPTION;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>PRAGMA EXCEPTION_INIT(<\/SPAN>e_insert_excep<\/SPAN>, -01400);<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>insert into departments<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>(<\/SPAN>department_id<\/SPAN>, <\/SPAN>department_name<\/SPAN>)<\/SPAN> values (280, NULL);<\/SPAN><\/P>
\n

exception<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>when <\/SPAN>e_insert_excep<\/SPAN> then<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>dbms_output.put_line<\/SPAN>(\u2018INSERT OPERATION FAILED\u2019);<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>dbms_output.put_line<\/SPAN>(SQLERRM);<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

 <\/P>
\n

G. \uc608\uc678 \ud2b8\ub7a9\uc5d0 \ub300\ud55c \ud568\uc218<\/P>
\n

<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>SQLCODE : <\/SPAN>\uc624\ub958 \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc22b\uc790 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>SQLERRM : <\/SPAN>\uc624\ub958 \ubc88\ud638\uc640 \uc5f0\uad00\ub41c \uba54\uc2dc\uc9c0\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n

ex)<\/P>
\n

DECLARE
error_code NUMBER;
error_message VARCHAR2(255);
BEGIN
…
EXCEPTION
…
WHEN OTHERS THEN
ROLLBACK;
error_code := SQLCODE<\/SPAN> ;
error_message := SQLERRM<\/SPAN> ;
INSERT INTO errors (e_user, e_date, error_code,
error_message) VALUES(USER,SYSDATE,error_code,
error_message);
END;
\/<\/P>
\n

 <\/P>
\n

H. \uc720\uc800 \uc815\uc758 \uc608\uc678 \ud2b8\ub7a9<\/P>
\n

– \uc751\uc6a9 \ud504\ub85c\uadf8\ub7a8\uc758 \uc694\uad6c\uc0ac\ud56d\uc5d0 \ub530\ub77c \uace0\uc720\uc758 \uc608\uc678\ub97c \uc815\uc758 \uac00\ub2a5<\/P>
\n

ex)<\/P>
\n

declare<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_deptno<\/SPAN> number := 500;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_name<\/SPAN> varchar2(20) := \u2018Testing\u2019;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>e_invalid_dept<\/SPAN> exception;<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>update departments set <\/SPAN>department_name<\/SPAN> = <\/SPAN>v_name<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>where <\/SPAN>department_id<\/SPAN> = <\/SPAN>v_deptno<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>if <\/SPAN>sql%notfound<\/SPAN> then<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>raise <\/SPAN>e_invalid_dept<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>end if;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>commit;<\/SPAN><\/P>
\n

exception<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>when <\/SPAN>e_invalid_dept<\/SPAN> then<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>dbms_output.put_line<\/SPAN>(\u2018No such department id.\u2019);<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

 <\/P>
\n

I. \uc11c\ube0c \ube14\ub85d\uc758 \uc608\uc678 \uc804\ub2ec<\/P>
\n

– \uc11c\ube0c \ube14\ub85d\uc740 \uc608\uc678\ub97c \ucc98\ub9ac\ud558\uac70\ub098, \ud3ec\ud568\ud558\ub294 \ube14\ub85d\uc73c\ub85c \uc608\uc678\ub97c \uc804\ub2ec \ud560 \uc218 \uc788\ub2e4.<\/P>
\n

DECLARE
    . . .
    e_no_rows exception;
    e_integrity exception;
    PRAGMA EXCEPTION_INIT (e_integrity, -2292);
BEGIN
    FOR c_record IN emp_cursor LOOP
    <\/SPAN>    <\/SPAN><\/SPAN>BEGIN<\/SPAN>
    <\/SPAN>    <\/SPAN>    <\/SPAN><\/SPAN><\/SPAN>SELECT …<\/SPAN>
    <\/SPAN>    <\/SPAN>    <\/SPAN><\/SPAN><\/SPAN>UPDATE …<\/SPAN>
    <\/SPAN>    <\/SPAN>    <\/SPAN><\/SPAN><\/SPAN>IF SQL%NOTFOUND THEN<\/SPAN>
    <\/SPAN>    <\/SPAN>    <\/SPAN>    <\/SPAN><\/SPAN><\/SPAN><\/SPAN>RAISE e_no_rows;<\/SPAN>
    <\/SPAN>    <\/SPAN>    <\/SPAN><\/SPAN><\/SPAN>END IF;<\/SPAN>
    <\/SPAN>    <\/SPAN><\/SPAN>END;<\/SPAN>
    END LOOP;
EXCEPTION
    WHEN e_integrity THEN …
    WHEN e_no_rows THEN …
END;
\/<\/P>
\n

 <\/P>
\n

J. RAISE_APPLICATION_ERROR \ud504\ub85c\uc2dc\uc800<\/P>
\n

\u00a7<\/SPAN><\/SPAN>Syntax<\/SPAN><\/DIV>
\n

raise_application_error<\/SPAN> (<\/SPAN>error_number<\/SPAN>, <\/SPAN><\/P>
\n

message[, {TRUE | FALSE} ] );<\/SPAN><\/P>
\n

\u00a7<\/SPAN><\/SPAN>error_number<\/SPAN> : <\/SPAN>\uc608\uc678\uc5d0 \ub300\ud55c \uc720\uc800 \uc9c0\uc815\ubc88\ud638 <\/SPAN>(-20,000 ~ -20,999)<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>message : <\/SPAN>\uc720\uc800\uac00 \uc9c0\uc815\ud55c \uc608\uc678 \uba54\uc2dc\uc9c0<\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ube44\ud45c\uc900<\/SPAN> <\/SPAN>\uc624\ub958 \ucf54\ub4dc \ubc0f \uc624\ub958 \uba54\uc2dc\uc9c0\ub97c \ubc18\ud658\ud558\uc5ec \ubbf8\ub9ac \uc815\uc758\ub41c \uc608\uc678\uac00 \ubc18\ud658\ub418\uc9c0 \uc54a\ub3c4\ub85d \ud560 \uc218 <\/SPAN>\uc788\uc74c<\/SPAN>.<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub2e4\uc74c\uacfc \uac19\uc740 \uc704\uce58\uc5d0\uc11c \uc0ac\uc6a9<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc2e4\ud589 \uc139\uc158<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc608\uc678 \uc139\uc158 <\/SPAN><\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>Oracle <\/SPAN>\uc11c\ubc84 \uc624\ub958\uc640 \uc77c\uce58\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \uc720\uc800\uc5d0\uac8c \uc624\ub958 \uc870\uac74\uc744 \ubc18\ud658<\/SPAN>.<\/SPAN><\/DIV>
\n
<\/DIV>
\n

– \uc2e4\ud589 \uc139\uc158\uc5d0\uc11c\uc758 \uc0ac\uc6a9<\/P>
\n

BEGIN
…
    DELETE FROM employees
        WHERE manager_id = v_mgr;
    <\/SPAN>IF SQL%NOTFOUND THEN<\/SPAN>
    <\/SPAN>    <\/SPAN><\/SPAN>RAISE_APPLICATION_ERROR(-20202,<\/SPAN> <\/SPAN><\/SPAN><\/SPAN>‘This is not a valid manager’);<\/SPAN>
    <\/SPAN><\/SPAN>END IF;<\/SPAN>
…<\/P>
\n

– \uc608\uc678 \uc139\uc158\uc5d0\uc11c\uc758 \uc0ac\uc6a9<\/P>
\n

…
EXCEPTION
    WHEN NO_DATA_FOUND THEN<\/SPAN>
    <\/SPAN>    <\/SPAN><\/SPAN><\/SPAN>RAISE_APPLICATION_ERROR (-20201, <\/SPAN>‘Manager is not a valid employee.’);<\/SPAN>
END;
\/<\/P>
\n

ex)<\/P>
\n

declare<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>no_emp<\/SPAN> exception;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>pragma <\/SPAN>exception_init<\/SPAN>(<\/SPAN>no_emp<\/SPAN>, -20001);<\/SPAN><\/P>
\n

begin<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>delete from employees<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>where <\/SPAN>employee_id<\/SPAN> = 9999;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>if <\/SPAN>sql%notfound<\/SPAN> then<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>raise_application_error<\/SPAN>(-20001, \u2018What!?!?!?!\u2019);<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>end if;<\/SPAN><\/P>
\n

exception<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>when <\/SPAN>no_emp<\/SPAN> then<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>dbms_output.put_line<\/SPAN>(\u2018no data found\u2019);<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>dbms_output.put_line<\/SPAN>(<\/SPAN>sqlerrm<\/SPAN>);<\/SPAN><\/P>
\n

end;<\/SPAN><\/P>
\n

\/<\/SPAN><\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P><\/p>\n","protected":false},"excerpt":{"rendered":"

8. PL\/SQL \uc608\uc678\ucc98\ub9ac   A. \uc608\uc678\ub780?   – SELECT \ubb38\uc774 \ud589\uc744 \ud558\ub098\ub9cc \uc77d\uc5b4 \ub4e4\uc77c \uac83\uc73c\ub85c \uc608\uc0c1\ud588\uc9c0\ub9cc \uc5ec\ub7ec \ud589\uc744 \uc77d\uc5b4 \uc624\ub958 \ubc1c\uc0dd\ud558\uba70 \ube14\ub85d\uc774 \uc885\ub8cc\ub428 – \uc704\uc640\uac19\uc774 \ub7f0\ud0c0\uc784\uc5d0 \ubc1c\uc0dd\ud558\ub294 \uc624\ub958\ub97c \uc608\uc678\ub77c\uace0 \ud55c\ub2e4. ex) declare   v_lname varchar2(15); begin   select last_name into v_lname   from employees   where first_name=\u2018John\u2019;   dbms_output.put_line (\u2018John\u2019\u2019s last name is : \u2018 […]<\/p>\n","protected":false},"author":1,"featured_media":1274,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile1.uf.21198C5056893AC8318EA1.png?fit=643%2C984","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1273"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1273"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1273\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1274"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1273"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}