{"id":1278,"date":"2016-01-03T15:35:55","date_gmt":"2016-01-03T15:35:55","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1278"},"modified":"2016-01-03T15:35:55","modified_gmt":"2016-01-03T15:35:55","slug":"9-plsql-%eb%82%b4%ec%9e%a5-%ed%94%84%eb%a1%9c%ec%8b%9c%ec%a0%80-%eb%b0%8f-%ed%95%a8%ec%88%98-%ec%86%8c%ea%b0%9c","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1278","title":{"rendered":"9. PL\/SQL \ub0b4\uc7a5 \ud504\ub85c\uc2dc\uc800 \ubc0f \ud568\uc218 \uc18c\uac1c"},"content":{"rendered":"

9. PL\/SQL \ub0b4\uc7a5 \ud504\ub85c\uc2dc\uc800 \ubc0f \ud568\uc218 \uc18c\uac1c<\/P>
\n

 <\/P>
\n

A. \ud504\ub85c\uc2dc\uc800 \ubc0f \ud568\uc218<\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uba85\uba85\ub41c <\/SPAN>PL\/SQL <\/SPAN>\ube14\ub85d<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>PL\/SQL <\/SPAN>\uc11c\ube0c\ud504\ub85c\ub7a8<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ube14\ub85d \uad6c\uc870<\/SPAN><\/DIV>
\n
–<\/SPAN><\/SPAN>\uc120\ud0dd\uc801 \uc120\uc5b8 \uc139\uc158<\/SPAN> (<\/SPAN>DECLARE <\/SPAN>\ud0a4\uc6cc\ub4dc \uc0ac\uc6a9<\/SPAN>X<\/SPAN>)<\/SPAN><\/DIV>
\n

  <\/SPAN> <\/SPAN><\/SPAN>  <\/SPAN>IS, AS <\/SPAN><\/SPAN>\ud0a4\uc6cc\ub4dc \ub2e4\uc74c\uc5d0 \ub098\uc634<\/SPAN><\/P>
\n

–<\/SPAN><\/SPAN>\ud544\uc218<\/SPAN> \uc2e4\ud589 \uc139\uc158 <\/SPAN>(BEGIN), END <\/SPAN>\ud0a4\uc6cc\ub4dc\ub85c \ub05d\ub0a8<\/SPAN><\/DIV>
\n
–<\/SPAN><\/SPAN>\uc120\ud0dd\uc801 \uc608\uc678 \ucc98\ub9ac \uc139\uc158<\/SPAN>(EXCEPTION)<\/SPAN><\/DIV>
\n

 <\/P>
\n

B. \uc775\uba85 \ube14\ub85d  VS \uc11c\ube0c \ud504\ub85c\uadf8\ub7a8<\/P>
\n

– \ucc28\uc774\uc810<\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

C. \ud504\ub85c\uc2dc\uc800 : \uad6c\ubb38<\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

\u00a7<\/SPAN><\/SPAN>MODE<\/SPAN><\/DIV>
\n
–<\/SPAN><\/SPAN>IN (<\/SPAN>\uae30\ubcf8\uac12<\/SPAN>) \/\/ OUT \/\/ IN OUT<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>DATATYPE<\/SPAN>  <\/SPAN><\/SPAN>– <\/SPAN>\ud30c\ub77c\ubbf8\ud130\uc758<\/SPAN> \ub370\uc774\ud130\uc720\ud615\uc740 \uba85\uc2dc\uc801 \ud06c\uae30 \uac00\uc9c8 \uc218<\/SPAN>
  <\/SPAN>  <\/SPAN><\/SPAN>\uc5c6\uc74c<\/SPAN> <\/SPAN>-> %TYPE <\/SPAN>\uc0ac\uc6a9<\/SPAN><\/DIV>
\n

 <\/P>
\n

D. PARAMETER MODES<\/P>
\n

<\/P>
\n

 <\/P>
\n

E. \ud504\ub85c\uc2dc\uc800 \uc791\uc131 \uc608\uc81c<\/P>
\n

  <\/P>
\n

CREATE TABLE <\/SPAN>dept<\/SPAN> <\/SPAN><\/P>
\n

AS SELECT * FROM departments;<\/SPAN><\/P>
\n

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

CREATE OR REPLACE PROCEDURE <\/SPAN>add_dept<\/SPAN> IS<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_dept_id<\/SPAN> <\/SPAN>dept.department_id%TYPE<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_dept_name<\/SPAN> <\/SPAN>dept.department_name%TYPE<\/SPAN>;<\/SPAN><\/P>
\n

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

  <\/SPAN><\/SPAN>v_dept_id<\/SPAN> := 280;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_dept_name<\/SPAN> := \u2018ST-Curriculum\u2019;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>INSERT INTO <\/SPAN>dept<\/SPAN> <\/SPAN>(<\/SPAN>department_id<\/SPAN>, <\/SPAN>department_name<\/SPAN>)<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>VALUES (<\/SPAN>v_dept_id<\/SPAN>, <\/SPAN>v_dept_name<\/SPAN>);<\/SPAN><\/P>
\n

  <\/SPAN>DBMS_OUTPUT.PUT_LINE (\u2018 Inserted \u2018 ||<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>  <\/SPAN> <\/SPAN>SQL%ROWCOUNT || \u2018 row \u2018 );<\/SPAN><\/SPAN><\/P>
\n

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

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

F. \uac1d\uccb4 \ubc0f \uac1d\uccb4 \uc18c\uc2a4 \ud655\uc778<\/P>
\n

\u00a7<\/SPAN><\/SPAN>user_objects<\/SPAN> <\/SPAN>\ud14c\uc774\ube14 <\/SPAN>\u2013 <\/SPAN>\uac1d\uccb4 \uc791\uc131 \ud6c4<\/SPAN>, <\/SPAN>\uc131\uacf5\uc801\uc778 \uc2e4\ud589 \uc5ec\ubd80 \ud655\uc778<\/SPAN><\/DIV>
\n

SELECT <\/SPAN>object_name<\/SPAN>, <\/SPAN>object_type<\/SPAN> <\/SPAN><\/P>
\n

FROM <\/SPAN>user_objects<\/SPAN>;<\/SPAN><\/P>
\n

\u00a7<\/SPAN><\/SPAN>user_source<\/SPAN> <\/SPAN>\ud14c\uc774\ube14 <\/SPAN>\u2013 <\/SPAN>\ud504\ub85c\uc2dc\uc800\uc758 \uc18c\uc2a4 \ud655\uc778 \uac00\ub2a5<\/SPAN><\/DIV>
\n

SELECT * FROM <\/SPAN>user_source<\/SPAN><\/P>
\n

WHERE name = \u2018ADD_DEPT\u2019;<\/SPAN><\/P><\/p>\n

 <\/p>\n

\u00a7<\/SPAN><\/SPAN>user_objects<\/SPAN> <\/SPAN>\ud14c\uc774\ube14<\/SPAN><\/DIV>
\n

<\/P>
\n

<\/P>
\n

set pages 50<\/SPAN><\/P>
\n

col name for a20<\/SPAN><\/P>
\n

col text for a80<\/SPAN><\/P>
\n

<\/P>
\n

<\/P>
\n

SELECT <\/SPAN>object_name<\/SPAN>, <\/SPAN>object_type<\/SPAN> <\/SPAN><\/P>
\n

FROM <\/SPAN>user_objects<\/SPAN><\/P>
\n

WHERE <\/SPAN>object_name<\/SPAN> <\/SPAN>= \u2018ADD_DEPT\u2019;<\/SPAN><\/P>
\n

<\/P><\/p>\n

 <\/p>\n

\u00a7<\/SPAN><\/SPAN>user_source<\/SPAN> <\/SPAN>\ud14c\uc774\ube14<\/SPAN><\/DIV>
\n

<\/P>
\n

 <\/P>
\n

G. \ud504\ub85c\uc2dc\uc800 \ud638\ucd9c<\/P>
\n

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

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

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

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

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

<\/P><\/p>\n

 <\/p>\n

SELECT <\/SPAN>department_id<\/SPAN>, <\/SPAN>department_name<\/SPAN><\/P>
\n

FROM <\/SPAN>dept<\/SPAN><\/P>
\n

WHERE <\/SPAN>department_id<\/SPAN> = 280;<\/SPAN><\/P>
\n

<\/P>
\n

 <\/P>
\n

H. \ud568\uc218 : \uad6c\ubb38 <\/P>
\n

<\/P>
\n

\u00a7<\/SPAN><\/SPAN>ARGUMENT: <\/SPAN>\ud568\uc218 <\/SPAN>\ud30c\ub77c\ubbf8\ud130\uc5d0<\/SPAN> \ubd80\uc5ec\ub41c \uc774\ub984<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>MODE: <\/SPAN>\ud30c\ub77c\ubbf8\ud130<\/SPAN> \uc720\ud615<\/SPAN>, IN <\/SPAN>\ud30c\ub77c\ubbf8\ud130\ub9cc<\/SPAN> \uc120\uc5b8\ub418\uc5b4\uc57c \ud568<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>RETURN <\/SPAN>datatype<\/SPAN>: <\/SPAN>\ud568\uc218\uc5d0 \uc758\ud574 \ubc18\ud658\ub41c \uac12\uc758 \ub370\uc774\ud130 \uc720\ud615<\/SPAN><\/DIV>
\n

 <\/P>
\n

ex)<\/P>
\n

CREATE OR REPLACE FUNCTION <\/SPAN>check_sal<\/SPAN> <\/SPAN><\/P>
\n

RETURN <\/SPAN>boolean<\/SPAN> <\/SPAN>IS<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_dept_id<\/SPAN> <\/SPAN>employees.department_id%TYPE<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_empno<\/SPAN> <\/SPAN>employees.employee_id%TYPE<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_sal<\/SPAN> <\/SPAN>employees.salary%TYPE<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_avg_sal<\/SPAN> <\/SPAN>employees.salary%TYPE<\/SPAN>;<\/SPAN><\/P>
\n

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

  <\/SPAN><\/SPAN>v_empno<\/SPAN> <\/SPAN>:= 205;<\/SPAN><\/P>
\n

  <\/SPAN>SELECT <\/SPAN><\/SPAN>salary, <\/SPAN>department_id<\/SPAN> <\/SPAN>INTO <\/SPAN>v_sal<\/SPAN>, <\/SPAN>v_dept_id<\/SPAN><\/P>
\n

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

  <\/SPAN>WHERE <\/SPAN><\/SPAN>employee_id<\/SPAN> = <\/SPAN>v_empno<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>SELECT <\/SPAN>avg<\/SPAN>(salary) <\/SPAN>INTO <\/SPAN>v_avg_sal<\/SPAN> <\/SPAN>FROM <\/SPAN>employees<\/SPAN><\/P>
\n

  <\/SPAN>WHERE <\/SPAN><\/SPAN>department_id<\/SPAN> <\/SPAN>= <\/SPAN>v_dept_id<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN>IF <\/SPAN><\/SPAN>v_sal<\/SPAN> > <\/SPAN>v_avg_sal<\/SPAN> <\/SPAN>THEN<\/SPAN><\/P>
\n

  <\/SPAN>RETURN TRUE;<\/SPAN><\/SPAN><\/P>
\n

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

  <\/SPAN>RETURN FALSE;<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN>END IF;<\/SPAN><\/SPAN><\/P>
\n

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

  <\/SPAN>WHEN NO_DATA_FOUND THEN<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN>RETURN NULL;<\/SPAN><\/SPAN><\/P>
\n

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

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

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

I. \ud568\uc218 \ud638\ucd9c<\/P>
\n

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

  <\/SPAN><\/SPAN>IF (<\/SPAN>check_sal<\/SPAN> IS NULL) THEN<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>DBMS_OUTPUT.PUT_LINE <\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>(\u2018The function returned NULL due to exception\u2019);<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>ELSIF (<\/SPAN>check_sal<\/SPAN>) THEN<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>DBMS_OUTPUT.PUT_LINE (\u2018 Salary > Average \u2019);<\/SPAN><\/P>
\n

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

  <\/SPAN><\/SPAN>DBMS_OUTPUT.PUT_LINE (\u2018 Salary < Average \u2018);<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>END IF;<\/SPAN><\/P>
\n

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

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

* DESCRIBE \uba85\ub839\uc5b4<\/P>
\n

\u00a7<\/SPAN><\/SPAN>DESCRIBE <\/SPAN>\uba85\ub839\uc744 \ud1b5\ud574\uc11c <\/SPAN>
<\/SPAN>\ud568\uc218\uc758 \uc778\uc218 \ubc0f \ubc18\ud658 \uc720\ud615 \ud655\uc778 \uac00\ub2a5<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud504\ub85c\uc2dc\uc800 \uc5ed\uc2dc <\/SPAN>DESCRIBE <\/SPAN>\uac00<\/SPAN>\ub2a5<\/SPAN><\/DIV>
\n

<\/P>
\n

 <\/P>
\n

J. \ud30c\ub77c\ubbf8\ud130\uac00 \ud3ec\ud568\ub41c \ud568\uc218 \uc608\uc81c<\/P>
\n

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

DROP FUNCTION <\/SPAN>check_sal<\/SPAN>;<\/SPAN><\/P>
\n

CREATE OR REPLACE FUNCTION <\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>check_sal<\/SPAN>(<\/SPAN>p_empno<\/SPAN> <\/SPAN>employees.employee_id%TYPE<\/SPAN>)<\/SPAN> <\/SPAN><\/P>
\n

RETURN <\/SPAN>boolean<\/SPAN> <\/SPAN>IS<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_dept_id<\/SPAN> <\/SPAN>employees.department_id%TYPE<\/SPAN>;<\/SPAN><\/P>
\n

 <\/SPAN>  <\/SPAN><\/SPAN>v_sal<\/SPAN> <\/SPAN>employees.salary%TYPE<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>v_avg_sal<\/SPAN> <\/SPAN>employees.salary%TYPE<\/SPAN>;<\/SPAN><\/P>
\n

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

  <\/SPAN>SELECT <\/SPAN><\/SPAN>salary, <\/SPAN>department_id<\/SPAN> <\/SPAN>INTO <\/SPAN>v_sal<\/SPAN>, <\/SPAN>v_dept_id<\/SPAN><\/P>
\n

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

  <\/SPAN><\/SPAN>WHERE <\/SPAN>employee_id<\/SPAN> = <\/SPAN>p_empno<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>SELECT <\/SPAN>avg<\/SPAN>(salary) <\/SPAN>INTO <\/SPAN>v_avg_sal<\/SPAN> <\/SPAN>FROM <\/SPAN>employees<\/SPAN><\/P>
\n

  <\/SPAN>WHERE <\/SPAN><\/SPAN>department_id<\/SPAN> <\/SPAN>= <\/SPAN>v_dept_id<\/SPAN>;<\/SPAN><\/P>
\n

  <\/SPAN>IF <\/SPAN><\/SPAN>v_sal<\/SPAN> > <\/SPAN>v_avg_sal<\/SPAN> <\/SPAN>THEN<\/SPAN><\/P>
\n

  <\/SPAN>RETURN TRUE;<\/SPAN><\/SPAN><\/P>
\n

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

  <\/SPAN>RETURN FALSE;<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN>END IF;<\/SPAN><\/SPAN><\/P>
\n

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

  <\/SPAN>WHEN NO_DATA_FOUND THEN<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN>RETURN NULL;<\/SPAN><\/SPAN><\/P>
\n

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

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

 <\/P>
\n

– \ud638\ucd9c<\/P>
\n

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

DBMS_OUTPUT.PUT_LINE(\u2018 Checking for employee with id 205 \u2018);<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>IF (<\/SPAN>check_sal<\/SPAN> (205) IS NULL) THEN<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>DBMS_OUTPUT.PUT_LINE (\u2018 The function returned NULL due to exception \u2018);<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>ELSIF (<\/SPAN>check_sal<\/SPAN> (205)) THEN<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>DBMS_OUTPUT.PUT_LINE (\u2018 Salary > Average \u2018);<\/SPAN><\/P>
\n

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

  <\/SPAN><\/SPAN>DBMS_OUTPUT.PUT_LINE (\u2018 Salary < Average \u2018);<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>END IF;<\/SPAN><\/P>
\n

DBMS_OUTPUT.PUT_LINE(\u2018 Checking for employee with id 70 \u2018);<\/SPAN><\/P>
\n

  <\/SPAN>IF (<\/SPAN><\/SPAN>check_sal<\/SPAN> (70) IS NULL) THEN<\/SPAN><\/P>
\n

  <\/SPAN>DBMS_OUTPUT.PUT_LINE (\u2018 The function returned NULL due to exception \u2018);<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN>ELSIF (<\/SPAN><\/SPAN>check_sal<\/SPAN> (70)) THEN<\/SPAN><\/P>
\n

  <\/SPAN>DBMS_OUTPUT.PUT_LINE (\u2018 Salary > Average \u2018);<\/SPAN><\/SPAN><\/P>
\n

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

  <\/SPAN>DBMS_OUTPUT.PUT_LINE (\u2018 Salary < Average \u2018);<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN>END IF;<\/SPAN><\/SPAN><\/P>
\n

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

 <\/P>
\n

<\/P><\/p>\n

 <\/p>\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

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

9. PL\/SQL \ub0b4\uc7a5 \ud504\ub85c\uc2dc\uc800 \ubc0f \ud568\uc218 \uc18c\uac1c   A. \ud504\ub85c\uc2dc\uc800 \ubc0f \ud568\uc218     \u00a7\uba85\uba85\ub41c PL\/SQL \ube14\ub85d \u00a7PL\/SQL \uc11c\ube0c\ud504\ub85c\ub7a8 \u00a7\ube14\ub85d \uad6c\uc870 –\uc120\ud0dd\uc801 \uc120\uc5b8 \uc139\uc158 (DECLARE \ud0a4\uc6cc\ub4dc \uc0ac\uc6a9X)      IS, AS \ud0a4\uc6cc\ub4dc \ub2e4\uc74c\uc5d0 \ub098\uc634 –\ud544\uc218 \uc2e4\ud589 \uc139\uc158 (BEGIN), END \ud0a4\uc6cc\ub4dc\ub85c \ub05d\ub0a8 –\uc120\ud0dd\uc801 \uc608\uc678 \ucc98\ub9ac \uc139\uc158(EXCEPTION)   B. \uc775\uba85 \ube14\ub85d  VS \uc11c\ube0c \ud504\ub85c\uadf8\ub7a8 – \ucc28\uc774\uc810   […]<\/p>\n","protected":false},"author":1,"featured_media":1279,"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\/cfile4.uf.2161F84B56893DF60B5A68.png?fit=820%2C180","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1278"}],"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=1278"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1278\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1279"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1278"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}