{"id":1248,"date":"2016-01-03T14:59:59","date_gmt":"2016-01-03T14:59:59","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1248"},"modified":"2016-01-03T14:59:59","modified_gmt":"2016-01-03T14:59:59","slug":"6-plsql-%ec%a1%b0%ed%95%a9-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%9c%a0%ed%98%95-%ec%9e%91%ec%97%85","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1248","title":{"rendered":"6. PL\/SQL \uc870\ud569 \ub370\uc774\ud130 \uc720\ud615 \uc791\uc5c5"},"content":{"rendered":"

6. PL\/SQL \uc870\ud569 \ub370\uc774\ud130 \uc720\ud615 \uc791\uc5c5<\/P>
\n

 <\/P>
\n

A. \uc870\ud569 \ub370\uc774\ud130 \uc720\ud615<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uc2a4\uce7c\ub77c \ud0c0\uc785\uacfc\ub294 \ub2ec\ub9ac \ub2e4\uc911 \uac12\uc744 \uac00\uc9c8 \uc218 \uc788\uc74c<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ubaa8\ub4e0 \uad00\ub828 \ub370\uc774\ud130\ub97c <\/SPAN>\u2018<\/SPAN>\ub2e8\uc77c \ub2e8\uc704<\/SPAN>\u2019<\/SPAN>\ub85c \ubcf4\uc720<\/SPAN>-> <\/SPAN>\uc26c\uc6b4 \uc561\uc138\uc2a4<\/SPAN>, <\/SPAN>\uc218\uc815<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>2<\/SPAN>\uac00\uc9c0 \uc720\ud615<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>1. PL\/SQL <\/SPAN>\ub808\ucf54\ub4dc<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>2. PL\/SQL <\/SPAN>\uceec\ub809\uc158 <\/SPAN><\/DIV>
\n
–<\/SPAN><\/SPAN>\uc5f0\uad00\ubc30\uc5f4<\/SPAN>(INDEX BY <\/SPAN>\ud14c\uc774\ube14<\/SPAN>)<\/SPAN><\/DIV>
\n
–<\/SPAN><\/SPAN>\uc911\ucca9 \ud14c\uc774\ube14<\/SPAN><\/DIV>
\n
–<\/SPAN><\/SPAN>VARRAY<\/SPAN><\/DIV>
\n

 <\/P>
\n

B. PL\/SQL \ub808\ucf54\ub4dc<\/P>
\n

<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uad00\ub828\uc740 \uc788\uc9c0\ub9cc \uc720\uc0ac\ud558\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\ub97c \ub17c\ub9ac\uc801 \ub2e8\uc704\ub85c \ucc98\ub9ac\ud560 \ub54c \uc774\uc6a9<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub2e4\uc591\ud55c \uc720\ud615\uc758 \ubcc0\uc218 \ubcf4\uc720 \uac00\ub2a5<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc9d1\ud569\uc801 \ub17c\ub9ac \ub2e8\uc704\uac00 \uc0dd\uc131\ub418\uc5b4<\/SPAN>, <\/SPAN>\uc561\uc138\uc2a4\uc640 \uc870\uc791\uc774 \uc26c\uc6cc\uc9d0<\/SPAN><\/DIV>
\n


** <\/SPAN><\/SPAN>\uc11c\ub85c \ub2e4\ub978 \ub370\uc774\ud130 \uc720\ud615\uc758 \uac12\uc744 \uc800\uc7a5\ud558\ub824\ub294 \uacbd\uc6b0<\/SPAN>, <\/SPAN>\ud55c\ubc88\uc5d0 <\/SPAN><\/P>
\n

    <\/SPAN><\/SPAN>\ud558\ub098\uc529\ub9cc \uc800\uc7a5\ud560 \ub54c \uc0ac\uc6a9<\/SPAN>!<\/SPAN><\/P>
\n

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

\u00a7<\/SPAN><\/SPAN>\u2018<\/SPAN>\ud544\ub4dc<\/SPAN>\u2019<\/SPAN>\ub77c\uace0 \ud558\ub294 \uad6c\uc131\uc694\uc18c<\/SPAN>(of <\/SPAN>\uc2a4\uce7c\ub77c<\/SPAN>, <\/SPAN>\ub808\ucf54\ub4dc<\/SPAN>, INDEX BY TABLE)<\/SPAN>\ub97c \ud558\ub098 \uc774\uc0c1 \ud3ec\ud568\ud574\uc57c \ud568<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>USER-DEFINED <\/SPAN>\ub370\uc774\ud130 \uc720\ud615<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud14c\uc774\ube14 \ud589\uc758 \ubd80\ubd84\uc9d1\ud569\uc77c \uc218 \uc788\uc74c<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub17c\ub9ac\uc801 \ub2e8\uc704\ub85c \ucc98\ub9ac<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud14c\uc774\ube14\uc5d0\uc11c \ud589\uc744 <\/SPAN>\ud328\uce58\ud558\uc5ec<\/SPAN> \ucc98\ub9ac\ud558\ub294 \ub370 \ud3b8\ub9ac<\/SPAN><\/DIV>
\n

 <\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uac01<\/SPAN> <\/SPAN>\ub808\ucf54\ub4dc\ub294 \ud544\uc694\ud55c \ub9cc\ud07c \ud544\ub4dc \uac00\uc9c8 \uc218 \uc788\uc74c<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ucd08\uae30\uac12 \ud560\ub2f9 \uac00\ub2a5<\/SPAN>, NOT NULL<\/SPAN> <\/SPAN>\uc815\uc758 \uac00\ub2a5<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud544\ub4dc \ucd08\uae30\ud654\ud560 \ub54c <\/SPAN>DEFAULT<\/SPAN>\uc640 <\/SPAN>:= <\/SPAN>\uc0ac\uc6a9 \uac00\ub2a5<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc120\uc5b8\ubd80\uc5d0\uc11c<\/SPAN> <\/SPAN>RECORD <\/SPAN>\uc720\ud615 \uc815\uc758 \ubc0f<\/SPAN>, USER-DEFINED <\/SPAN>\uc720\ud615 \uc120\uc5b8<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc911\ucca9 \ub808\ucf54\ub4dc\ub97c \uc120\uc5b8\ud558\uace0 \ucc38\uc870\ud560 \uc218 \uc788\uc74c<\/SPAN>
<\/SPAN>(<\/SPAN>\ud55c \ub808\ucf54\ub4dc\uac00 \ub2e4\ub978 \ub808\ucf54\ub4dc\uc758 \uad6c\uc131\uc694\uc18c\uac00 \ub418\ub294 \uac83<\/SPAN>)<\/SPAN><\/DIV><\/SPAN>
\n

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

C. PL\/SQL \ub808\ucf54\ub4dc \uc0dd\uc131<\/SPAN><\/P>
\n

<\/P>
\n

 <\/P>
\n

<\/P>
\n

[ TYPE <\/SPAN>\uc120\uc5b8 <\/SPAN>]<\/SPAN><\/P>
\n

\u00a7<\/SPAN><\/SPAN>DECLARE <\/SPAN>\uc139\uc158\uc5d0\uc11c \ub808\ucf54\ub4dc <\/SPAN>\u201c<\/SPAN>\uc815\uc758<\/SPAN>\u201d<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub808\ucf54\ub4dc \uc720\ud615\uc758 \ub0b4\ubd80 \uad6c\uc131 \uc694\uc18c \uc120\uc5b8<\/SPAN>, <\/SPAN>\uc120\ud0dd\uc801\uc73c\ub85c \ucd08\uae30\ud654<\/SPAN><\/DIV>
\n

 <\/P>
\n

<\/P>
\n

[ USER-DEFINED <\/SPAN>\ub808\ucf54\ub4dc \uc120\uc5b8 <\/SPAN>]<\/SPAN><\/P>
\n

\u00a7<\/SPAN><\/SPAN>DECLARE <\/SPAN>\uc139\uc158\uc5d0\uc11c \ub808\ucf54\ub4dc \uc815\uc758 \ud6c4<\/SPAN>, <\/SPAN>
USER-DEFINED <\/SPAN><\/SPAN>\ub808\ucf54\ub4dc \uc120\uc5b8<\/SPAN><\/DIV>
\n

 <\/P>
\n

D. PL\/SQL \ub808\ucf54\ub4dc \uad6c\uc870<\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

E. %ROWTYPE \uc18d\uc131<\/P>
\n

<\/P>
\n

\u00a7<\/SPAN><\/SPAN>DB <\/SPAN>\ud14c\uc774\ube14 \ub610\ub294 <\/SPAN>\ubdf0\uc758<\/SPAN> \uc5f4 \uceec\ub809\uc158\uc5d0 \ub530\ub77c \ubcc0\uc218 \uc120\uc5b8<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>%ROWTYPE <\/SPAN>\uc55e\uc5d0\ub294 <\/SPAN>DB <\/SPAN>\ud14c\uc774\ube14 \ub610\ub294 <\/SPAN>\ubdf0<\/SPAN> \uc774\ub984\uc744 <\/SPAN>\uc811\ub450\uc5b4\ub85c<\/SPAN> \ubd99\uc784<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub808\ucf54\ub4dc\uc758 \ud544\ub4dc\ub294 \ud14c\uc774\ube14<\/SPAN> <\/SPAN>\ub610\ub294 <\/SPAN>\ubdf0\uc758<\/SPAN> \uc5f4\uc5d0\uc11c<\/SPAN>
<\/SPAN>\uc774\ub984 \ubc0f \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uac00\uc838\uc628\ub2e4<\/SPAN>.
\n

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

\u00a7<\/SPAN><\/SPAN>\ud14c\uc774\ube14 \ub610\ub294 <\/SPAN>\ubdf0\uc758<\/SPAN> \uc804\uccb4 \ud589\uc744 \ud3ec\ud568\ud560 \uc218 \uc788\ub294 \ub808\ucf54\ub4dc\ub97c \uc120\uc5b8\ud560 \ub54c \uc0ac\uc6a9<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub808\ucf54\ub4dc\ub294 \ucee4\uc11c\ub098 \ucee4\uc11c \ubcc0\uc218\uc5d0\uc11c <\/SPAN>\ud328\uce58\ud55c<\/SPAN> \uc804\uccb4 \ud589\uc744 \uc800\uc7a5\ud560 \uc218 \uc788\ub2e4<\/SPAN>.<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\u201c RECORD_NAME.FILED_NAME \u201c <\/SPAN>\ud615\uc2dd\uc73c\ub85c \uac1c\ubcc4 \ud544\ub4dc\ub97c <\/SPAN>
<\/SPAN>\ucc38\uc870\ud560 \ub54c\ub294 <\/SPAN>\u2018<\/SPAN>\uc810 \ud45c\uae30\ubc95<\/SPAN>\u2019 <\/SPAN>\uc0ac\uc6a9<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud544<\/SPAN>\ub4dc<\/SPAN> \uac12 \ud560\ub2f9 <\/SPAN>\u201cRECORD_NAME.FIELD_NAME := VALUE;<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>SELECT <\/SPAN>\ub610\ub294 <\/SPAN>FETCH<\/SPAN> <\/SPAN>\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub808\ucf54\ub4dc\uc5d0 \uac12 \ud560\ub2f9 \uac00\ub2a5<\/SPAN><\/DIV>
\n

 <\/P>
\n

F. PL\/SQL \ub808\ucf54\ub4dc \uc0dd\uc131 \uc608\uc81c<\/P>
\n

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

 <\/SPAN><\/SPAN>  <\/SPAN>TYPE <\/SPAN><\/SPAN>t_rec<\/SPAN> IS RECORD<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>(<\/SPAN>v_sal<\/SPAN> number(8),<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN> <\/SPAN><\/SPAN>v_minsal<\/SPAN> number(8) default 1000,<\/SPAN><\/P>
\n

  <\/SPAN> <\/SPAN><\/SPAN>v_hire_date<\/SPAN> <\/SPAN>employees.hire_date%type<\/SPAN>,<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN> <\/SPAN><\/SPAN>v_recl<\/SPAN> <\/SPAN>employees%rowtype<\/SPAN>);<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>v_myrec<\/SPAN> <\/SPAN>t_rec<\/SPAN>;<\/SPAN><\/P>
\n

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

   <\/SPAN><\/SPAN>v_myrec.v_sal<\/SPAN> := <\/SPAN>v_myrec.v_minsal<\/SPAN> + 500;<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>v_myrec.v_hire_date<\/SPAN> := <\/SPAN>sysdate<\/SPAN>;<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN>SELECT * INTO <\/SPAN><\/SPAN>v_myrec.v_recl<\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>FROM employees WHERE<\/SPAN>  <\/SPAN><\/SPAN>employee_id<\/SPAN> = 100;<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN>DBMS_OUTPUT.PUT_LINE(<\/SPAN><\/SPAN>v_myrec.v_recl.last_name<\/SPAN> ||\u2019 \u2018||<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>to_char<\/SPAN>(<\/SPAN>v_myrec.v_hire_date<\/SPAN>) ||\u2019 \u2018|| <\/SPAN>to_char<\/SPAN>(<\/SPAN>v_myrec.v_sal<\/SPAN>));<\/SPAN><\/P>
\n

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

 <\/P>
\n

G. %ROWTYPE \uc18d\uc131\uc758 \uc7a5\uc810<\/P><\/p>\n

 <\/p>\n

\u00a7<\/SPAN><\/SPAN>\uae30\ubcf8 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f4\uc758 \uac1c\uc218\uc640 \ub370\uc774\ud130 \ud0c0\uc785\uc744 \uc54c \ud544\uc694 \uc5c6\uc74c<\/SPAN>
<\/SPAN>\ub7f0\ud0c0\uc784\uc5d0 \ubcc0\uacbd\ub420 \uc218 \uc788\uc74c<\/SPAN>
<\/SPAN>-> <\/SPAN>\uc720\uc9c0 \uad00\ub9ac\uac00 \ub2e8\uc21c\ud654 \ub428<\/SPAN>. <\/SPAN>\uae30\ubcf8 \ud14c\uc774\ube14\uc774 \ubcc0\uacbd\ub418\ub294 \uacbd\uc6b0<\/SPAN>, <\/SPAN>
<\/SPAN>    <\/SPAN><\/SPAN>\uc774 \uc18d\uc131\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc120\uc5b8\ub41c \ubcc0\uc218\uc758 \ub370\uc774\ud130 \ud0c0\uc785\ub3c4 \ub3d9\uc801\uc73c\ub85c<\/SPAN>
    <\/SPAN><\/SPAN>\ubcc0\uacbd\ub428<\/SPAN>.<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>DDL<\/SPAN>\ubb38\uc774 \ud14c\uc774\ube14\uc5d0\uc11c \uc5f4\uc744 \ubcc0\uacbd\ud560 \uacbd\uc6b0<\/SPAN>, PL\/SQL <\/SPAN>\ud504\ub85c\uadf8\ub7a8 \ub2e8\uc704\uac00 \ubb34\ud6a8\ud654\ub428<\/SPAN>. <\/SPAN>
=> <\/SPAN><\/SPAN>\ud504\ub85c\uadf8\ub7a8 <\/SPAN>\uc7ac\ucef4\ud30c\uc77c\ub418\uba74<\/SPAN> \uc790\ub3d9\uc73c\ub85c \uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14 \ud615\uc2dd \ubc18\uc601<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\u2018SELECT * <\/SPAN>\ubb38<\/SPAN>\u2019, \u2018INSERT, UPDATE<\/SPAN>\ubb38 <\/SPAN>(<\/SPAN>\ud589 \ub808\ubca8<\/SPAN>)\u2019 <\/SPAN>\uc774\uc6a9\ud55c <\/SPAN>
<\/SPAN>\ud589 \uac80\uc0c9\uc5d0 \uc720\uc6a9<\/SPAN><\/DIV>
\n

ex)<\/P>
\n

1)<\/P>
\n

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

  <\/SPAN><\/SPAN>(EMPNO NUMBER(4),<\/SPAN>  <\/SPAN>ENAME VARCHAR2(10),<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN> <\/SPAN>JOB<\/SPAN><\/SPAN> <\/SPAN>VARCHAR2(9),<\/SPAN>  <\/SPAN>MGR NUMBER(4),<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN> <\/SPAN>HIREDATE DATE, <\/SPAN>  <\/SPAN>LEAVEDATE DATE,<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN> <\/SPAN>SAL NUMBER(7,2), <\/SPAN>  <\/SPAN>COMM NUMBER(7,2),<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN> <\/SPAN>DEPTNO NUMBER(2));<\/SPAN><\/SPAN><\/P><\/p>\n

 <\/p>\n

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

   <\/SPAN><\/SPAN>v_employee_number<\/SPAN> number := 124;<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>v_emp_rec<\/SPAN> <\/SPAN>employees%ROWTYPE<\/SPAN>;<\/SPAN><\/P>
\n

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

   <\/SPAN>SELECT * INTO <\/SPAN><\/SPAN>v_emp_rec<\/SPAN> FROM employees<\/SPAN><\/P>
\n

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

 <\/SPAN><\/SPAN>  <\/SPAN>INSERT INTO <\/SPAN><\/SPAN>retired_emps<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN>VALUES(<\/SPAN><\/SPAN>v_emp_rec.employee_id<\/SPAN>, <\/SPAN>v_emp_rec.last_name<\/SPAN>,<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>             <\/SPAN><\/SPAN>v_emp_rec.job_id<\/SPAN>, <\/SPAN>v_emp_rec.manager_id<\/SPAN>,<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>             <\/SPAN><\/SPAN>v_emp_rec.hire_date<\/SPAN>, <\/SPAN>sysdate<\/SPAN>,<\/SPAN><\/P>
\n

              <\/SPAN><\/SPAN>v_emp_rec.salary<\/SPAN>, <\/SPAN>v_emp_rec.commission_pct<\/SPAN>,<\/SPAN><\/P>
\n

              <\/SPAN><\/SPAN>v_emp_rec.department_id<\/SPAN>);<\/SPAN><\/P>
\n

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

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

SELECT * FROM <\/SPAN>retired_emps<\/SPAN>;<\/SPAN><\/P>
\n

<\/P>
\n

2) INSERT<\/P>
\n

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

   <\/SPAN><\/SPAN>v_employee_number<\/SPAN> number := 124;<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>v_emp_rec<\/SPAN> <\/SPAN>retired_emps%ROWTYPE<\/SPAN>;<\/SPAN><\/P>
\n

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

   <\/SPAN>SELECT <\/SPAN><\/SPAN>employee_id<\/SPAN>, <\/SPAN>last_name<\/SPAN>, <\/SPAN>job_id<\/SPAN>, <\/SPAN>manager_id<\/SPAN>, <\/SPAN><\/P>
\n

              <\/SPAN><\/SPAN>hire_date<\/SPAN>, <\/SPAN>hire_date<\/SPAN>, salary, <\/SPAN>commission_pct<\/SPAN>,<\/SPAN><\/P>
\n

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

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

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

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>INSERT INTO <\/SPAN>retired_emps<\/SPAN> VALUES <\/SPAN>v_emp_rec<\/SPAN>;<\/SPAN><\/P>
\n

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

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

SELECT * FROM <\/SPAN>retired_emps<\/SPAN>;<\/SPAN><\/P>
\n

<\/P>
\n

3) update<\/P>
\n

SET VERIFY OFF<\/SPAN><\/P>
\n

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

   <\/SPAN><\/SPAN>v_employee_number<\/SPAN> number := 124;<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>v_emp_rec<\/SPAN> <\/SPAN>retired_emps%ROWTYPE<\/SPAN>;<\/SPAN><\/P>
\n

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

 <\/SPAN><\/SPAN>  <\/SPAN>SELECT * INTO <\/SPAN><\/SPAN>v_emp_rec<\/SPAN> FROM <\/SPAN>retired_emps<\/SPAN>;<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>v_emp_rec.leavedate<\/SPAN> :=CURRENT_DATE;<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>UPDATE<\/SPAN> <\/SPAN>retired_emps<\/SPAN> <\/SPAN>SET ROW = <\/SPAN>v_emp_rec<\/SPAN> <\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN>WHERE <\/SPAN><\/SPAN>empno<\/SPAN> = <\/SPAN>v_employee_number<\/SPAN>;<\/SPAN><\/P>
\n

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

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

SELECT * FROM <\/SPAN>retired_emps<\/SPAN>;<\/SPAN><\/P>
\n

<\/P>
\n

 <\/P>
\n

H. PL\/SQL \uceec\ub809\uc158<\/P>
\n

<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\ub370\uc774\ud130\ub97c \ub2e8\uc77c \ub2e8\uc704\ub85c \ucc98\ub9ac\ud558\ub294 \ub370 \uc0ac\uc6a9<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub3d9\uc77c\ud55c \ub370\uc774\ud130 \uc720\ud615\uc758 \uac12\uc744 \uc800\uc7a5\ud558\ub294 \uacbd\uc6b0\uc5d0 \uc0ac\uc6a9<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uceec\ub809\uc158 \uc720\ud615<\/SPAN><\/DIV>
\n
–<\/SPAN><\/SPAN>\uc5f0\uad00 \ubc30\uc5f4 <\/SPAN>(INDEX BY <\/SPAN>\ud14c\uc774\ube14<\/SPAN>)<\/SPAN><\/DIV>
\n
–<\/SPAN><\/SPAN>\uc911\ucca9 \ud14c\uc774\ube14<\/SPAN><\/DIV>
\n
–<\/SPAN><\/SPAN>VARRAY<\/SPAN><\/DIV>
\n
<\/DIV>
\n

 <\/P>
\n

I.  \uc5f0\uad00 \ubc30\uc5f4(INDEX BY TABLE)<\/P>
\n

 <\/P>
\n

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

 <\/p>\n

\u00a7<\/SPAN><\/SPAN>\uc5f0\uad00 \ubc30\uc5f4\uc740 <\/SPAN>USER-DEFINED <\/SPAN>\uc870\ud569 \ub370\uc774\ud130 \uc720\ud615<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\u2018<\/SPAN>\ud0a4<\/SPAN>–<\/SPAN>\uac12<\/SPAN>\u2019<\/SPAN> \uc30d\uc758 \uc9d1\ud569<\/SPAN><\/DIV>
\n

<\/P>
\n

<\/P>
\n

<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uc5f0\uad00 \ubc30\uc5f4\uc740 <\/SPAN>\u201c<\/SPAN>\ub450 \uac1c\uc758 \uc5f4<\/SPAN>\u201d<\/SPAN>\uc774 \uc788\ub294 <\/SPAN>PL\/SQL <\/SPAN>\uceec\ub809\uc158<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc815\uc218 \ub610\ub294 \ubb38\uc790\uc5f4 \ub370\uc774\ud130 \ud0c0\uc785\uc758 <\/SPAN>PRIMARY KEY <\/SPAN>\uc5f4<\/SPAN>
-> <\/SPAN><\/SPAN>\uc774 \uac12\uc744 \uc778\ub371\uc2a4\ub85c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \uc800\uc7a5<\/SPAN>
***<\/SPAN><\/SPAN>\ud0a4 \uac12\uc740 \uc21c\ucc28\uc801\uc774\uc9c0 \uc54a\uc744 \uc218\ub3c4 \uc788\uc74c<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc2a4\uce7c\ub77c<\/SPAN> <\/SPAN>\ub610\ub294 \ub808\ucf54\ub4dc \uc720\ud615\uc758 \uc5f4<\/SPAN>
-> <\/SPAN><\/SPAN>\uac12\uc744 \ubcf4\uc720
\n

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

\u00a7<\/SPAN><\/SPAN>\uc5f0\uad00 \ubc30\uc5f4\uc740 \uc120\uc5b8 \uc2dc \ucc44\uc6cc\uc9c0\uc9c0 \uc54a\uc74c<\/SPAN>
=> <\/SPAN><\/SPAN>\ucd08\uae30\ud654 \ubd88\uac00<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc5f0\uad00 \ubc30\uc5f4\uc744 \ucc44\uc6b0\ub824\uba74 \uba85\uc2dc\uc801 <\/SPAN>\uc2e4\ud589\ubb38<\/SPAN> \ud544\uc694<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>DB <\/SPAN>\ud14c\uc774\ube14\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \uc5f0\uad00 \ubc30\uc5f4\uc758 \ud06c\uae30\uc5d0\ub3c4 \uc81c\uc57d \uc5c6\uc74c<\/SPAN>
=> <\/SPAN><\/SPAN>\uc0c8 \ud589\uc774 \ucd94\uac00\ub428\uc5d0 \ub530\ub77c \ud589 \uc218\uac00 \ub3d9\uc801\uc73c\ub85c \ub298\uc5b4\ub0a0 \uc218 \uc788\uc74c<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud0a4\ub294 \uc21c\ucc28\uc801\uc774 \uc544\ub2d0 \uc218 \uc788\uc74c<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ud0a4\ub294 \uc591\uc218 \ubc0f \uc74c\uc218\uc77c \uc218 \uc788\uc74c<\/SPAN><\/DIV>
\n

 <\/P>
\n

J. \uc5f0\uad00 \ubc30\uc5f4\uc758 \uad6c\uc870<\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

[ UNIQUE KEY <\/SPAN>\uc5f4\uc758 \ub370\uc774\ud130 \ud0c0\uc785 <\/SPAN>]<\/SPAN><\/P>
\n

\u00a7<\/SPAN><\/SPAN>BINARY_INTEGER \/ PLS_INTEGER<\/SPAN>\uc778 \uc22b\uc790<\/SPAN>
number <\/SPAN><\/SPAN>\ubcf4\ub2e4 \uc801\uc740 \uc800\uc7a5\uc601\uc5ed \ud544\uc694<\/SPAN>, <\/SPAN>\uc0b0\uc220\uc5f0\uc0b0\uc740<\/SPAN>
number <\/SPAN><\/SPAN>\ubcf4\ub2e4 \ube60\ub984<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>VARCHAR2 <\/SPAN>\ub610\ub294 \ud558\uc704 \uc601\uc5ed<\/SPAN><\/DIV>
\n

[ VALUE <\/SPAN>\uc5f4\uc758 <\/SPAN>\ub370\uc774\ud130 \ud0c0\uc785 <\/SPAN>]<\/SPAN><\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uc2a4\uce7c\ub77c \ud0c0\uc785<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ub808\ucf54\ub4dc \ud0c0\uc785<\/SPAN><\/DIV>
\n

 <\/P>
\n

K. \uc5f0\uad00\ubc30\uc5f4 \uc0dd\uc131 \ub2e8\uacc4<\/P>
\n

<\/P>
\n

 <\/P>
\n

L. \uc5f0\uad00\ubc30\uc5f4 \uc0dd\uc131 \ubc0f \uc561\uc138\uc2a4<\/P>
\n

 <\/P>
\n

<\/P>
\n

M. INDEX BY TABLE \uba54\uc18c\ub4dc<\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

O. INDEX BY RECORD TABLE \uc635\uc158<\/P>
\n

\u00a7<\/SPAN><\/SPAN>DB <\/SPAN>\ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ud544\ub4dc\uc5d0 \ub300\ud55c \uc815\ubcf4\ub97c \ud558\ub098\uc758 \ubc30\uc5f4 \uc815\uc758\uc5d0<\/SPAN>
<\/SPAN>\uc800\uc7a5\ud560 \uc218 \uc788\uc74c<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>%ROWTYPE <\/SPAN>\uc18d\uc131\uc744 \uc0ac\uc6a9<\/SPAN>, <\/SPAN>\ud14c\uc774\ube14\uc758 \ud55c \ud589\uc744 \ub098\ud0c0\ub0b4\ub294 <\/SPAN>
<\/SPAN>\ub808\ucf54\ub4dc \uc120\uc5b8<\/SPAN><\/DIV>
\n

 <\/P>
\n

ex)<\/P>
\n

1)<\/P>
\n

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

 <\/SPAN><\/SPAN>  <\/SPAN>TYPE <\/SPAN><\/SPAN>dept_table_type<\/SPAN> IS TABLE OF<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN>  <\/SPAN><\/SPAN>departments%ROWTYPE<\/SPAN> <\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN>INDEX BY PLS_INTEGER;<\/SPAN><\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>dept_table<\/SPAN> <\/SPAN>dept_table_type<\/SPAN>;<\/SPAN><\/P>
\n

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

 <\/SPAN><\/SPAN>  <\/SPAN>SELECT * INTO <\/SPAN><\/SPAN>dept_table<\/SPAN>(1) FROM departments<\/SPAN><\/P>
\n

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

   <\/SPAN>DBMS_OUTPUT.PUT_LINE(<\/SPAN><\/SPAN>dept_table<\/SPAN>(1).<\/SPAN>department_id<\/SPAN> ||\u2019 \u2018||<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN>  <\/SPAN><\/SPAN>dept_table<\/SPAN>(1).<\/SPAN>department_name<\/SPAN> ||\u2019 \u2018||<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN>  <\/SPAN><\/SPAN>dept_table<\/SPAN>(1).<\/SPAN>manager_id<\/SPAN>);<\/SPAN><\/P>
\n

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

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

2)<\/P>
\n

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

  <\/SPAN>TYPE <\/SPAN><\/SPAN>emp_table_type<\/SPAN> IS TABLE OF<\/SPAN><\/P>
\n

  <\/SPAN>   <\/SPAN><\/SPAN>employees%ROWTYPE<\/SPAN>   <\/SPAN>INDEX BY PLS_INTEGER;<\/SPAN><\/SPAN><\/P>
\n

  <\/SPAN><\/SPAN>my_emp_table<\/SPAN> <\/SPAN>  <\/SPAN><\/SPAN>emp_table_type<\/SPAN>;<\/SPAN><\/P>
\n

 <\/SPAN><\/SPAN> <\/SPAN><\/SPAN>max_count<\/SPAN> <\/SPAN>  <\/SPAN>NUMBER(3) := 104;<\/SPAN><\/SPAN><\/P>
\n

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

  <\/SPAN>FOR I IN 100..max_count<\/SPAN><\/SPAN><\/P>
\n

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

  <\/SPAN><\/SPAN>SELECT * INTO <\/SPAN>my_emp_table<\/SPAN>(i) FROM employees<\/SPAN><\/P>
\n

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

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

 <\/SPAN><\/SPAN> <\/SPAN>FOR I IN my_emp_table.FIRST<\/SPAN>..<\/SPAN><\/SPAN>my_emp_table.LAST<\/SPAN><\/SPAN><\/P>
\n

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

  <\/SPAN><\/SPAN>DBMS_OUTPUT.PUT_LINE(<\/SPAN>my_emp_table<\/SPAN>(i).<\/SPAN>last_name<\/SPAN>);<\/SPAN><\/P>
\n

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

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

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

 <\/P>
\n

P. \uc911\ucca9\ud14c\uc774\ube14<\/P>
\n

 <\/P>
\n

<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uc911\ucca9 \ud14c\uc774\ube14\uc758 \uae30\ub2a5\uc740 \uc5f0\uad00 \ubc30\uc5f4\uacfc \ube44\uc2b7\ud558\uc9c0\ub9cc<\/SPAN>
<\/SPAN>\uc911\ucca9 \ud14c\uc774\ube14 \uad6c\ud604\uc5d0\uc11c \ucc28\uc774\uac00 \uc788\uc74c<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc5f0\uad00 \ubc30\uc5f4\uacfc \ub2ec\ub9ac \uc911\ucca9 \ud14c\uc774\ube14\uc740 <\/SPAN>DB<\/SPAN>\uc5d0 \uc800\uc7a5 \uac00\ub2a5<\/SPAN>
— <\/SPAN><\/SPAN>\ud56d\uc0c1 \uc21c\uc11c \uc5c6\uc774 \uc800\uc7a5\ub428<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc911\ucca9 \ud14c\uc774\ube14\uc758 \ud06c\uae30 \uc5ed\uc2dc \ub3d9\uc801\uc73c\ub85c \uc99d\uac00<\/SPAN>
<\/SPAN>\ud558\uc9c0\ub9cc<\/SPAN>! <\/SPAN>\ucd5c\ub300 <\/SPAN>2GB<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>UNIQUE KEY<\/SPAN>\uac12\uc774 \uc74c\uc218\uc77c \uc218 \uc5c6\uc74c<\/SPAN>
<\/SPAN>\uccab\ubc88\uc9f8<\/SPAN> \uc5f4\uc744 \ud0a4\ub85c \ucc38\uc870\ud558\uc9c0\ub9cc<\/SPAN>, <\/SPAN>\uc911\ucca9 \ud14c\uc774\ube14\uc5d0\ub294 \ud0a4 \uc5c6\uc74c<\/SPAN>
-> <\/SPAN><\/SPAN>\uc22b\uc790\uc5f4\uc774<\/SPAN> \uc788\uc74c<\/SPAN><\/DIV>
\n

 <\/P>
\n

<\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uc5f0\uad00 \ubc30\uc5f4\uacfc \ub2ec\ub9ac <\/SPAN>\u2018INDEX BY\u2019 <\/SPAN>\uc808\uc774 \uc5c6\uc74c<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ucd08\uae30\ud654 \uac00\ub2a5<\/SPAN>, <\/SPAN>\ucd08\uae30\ud654 \ud558\uc9c0 \uc54a\uc73c\uba74 <\/SPAN>NULL<\/SPAN>\ub85c \ucd08\uae30\ud654<\/SPAN><\/DIV>
\n

 <\/P>
\n

Q. VARRAY<\/P>
\n

 <\/P>
\n

<\/P>
\n

 <\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uac00\ubcc0 \ud06c\uae30 \ubc30\uc5f4\uc774\uba70<\/SPAN>, <\/SPAN>\ud06c\uae30\uc5d0 \uc81c\uc57d\uc774 \uc788\ub2e4\ub294 \uc810\uc744 \uc81c\uc678\ud558\uace0<\/SPAN>
\u2018<\/SPAN><\/SPAN>\uc5f0\uad00<\/SPAN> <\/SPAN>\ubc30\uc5f4<\/SPAN>\u2019<\/SPAN>\uacfc <\/SPAN>\ube44\uc2b7<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>VARRAY <\/SPAN>\uc720\ud615\uc758 \ud56d\ubaa9\uc744 <\/SPAN>VARRAYs <\/SPAN>\ub77c\uace0 \ud568<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>VARRAYs <\/SPAN>\uc5d0\ub294 \uace0\uc815\ub41c <\/SPAN>\uc0c1\ud55c\uac12\uc774<\/SPAN> \uc788\uc74c<\/SPAN>
<\/SPAN>-> <\/SPAN>\uc120\uc5b8 \uc2dc <\/SPAN>\uc0c1\ud55c\uac12<\/SPAN> \uc9c0\uc815\ud574\uc57c \ud568<\/SPAN>!<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\ucd5c\ub300 \ud06c\uae30<\/SPAN>: 2GB<\/SPAN><\/DIV>
\n
<\/DIV>
\n

 <\/P>
\n

\u00a7<\/SPAN><\/SPAN>\uc911\ucca9 \ud14c\uc774\ube14\uacfc\uc758 \ucc28\uc774\uc810<\/SPAN>: \u2018<\/SPAN>\ubb3c\ub9ac\uc801 \uc800\uc7a5 \ubaa8\ub4dc<\/SPAN>\u2019<\/SPAN>
— VARRAY<\/SPAN><\/SPAN>\uc758 \ud06c\uae30\uac00 <\/SPAN>4KB<\/SPAN>\ubcf4\ub2e4 \uc791\uc73c\uba74<\/SPAN> VARRAY<\/SPAN>\uc758 \uc694\uc18c\ub294<\/SPAN>
   <\/SPAN><\/SPAN>\ud14c\uc774\ube14 \ub370\uc774\ud130\uc640 \ud568\uaed8 <\/SPAN>\uc778\ub77c\uc778\uc73c\ub85c<\/SPAN> \uc800\uc7a5\ub41c\ub2e4<\/SPAN>. (<\/SPAN>\uc911\ucca9 \ud14c\uc774\ube14\uc740 <\/SPAN>
   <\/SPAN><\/SPAN>\uc21c\uc11c \uc0c1\uad00\uc5c6\uc774 \ud56d\uc0c1 \uc800\uc7a5<\/SPAN>)<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>SQL<\/SPAN>\uc744 \uc0ac\uc6a9\ud574\uc11c <\/SPAN>DB<\/SPAN>\uc5d0 <\/SPAN>VARRAY <\/SPAN>\uc720\ud615 \uc0dd\uc131 <\/SPAN>\uac00\ub2a5
\n

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

<\/DIV>
\n
<\/DIV>
\n
<\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>VARRAY<\/SPAN>\uc758 \ud06c\uae30\ub294 <\/SPAN>3<\/SPAN>\uc73c\ub85c \uc81c\ud55c\ub428 <\/SPAN>-> <\/SPAN>\uc989<\/SPAN>, <\/SPAN>\uc694\uc18c\uc758 \uac1c\uc218<\/SPAN><\/DIV>
\n
\u00a7<\/SPAN><\/SPAN>\uc0dd\uc131\uc790<\/SPAN> \uc774\uc6a9<\/SPAN>, <\/SPAN>\ucd08\uae30\ud654 \uac00\ub2a5<\/SPAN><\/DIV>
\n
<\/DIV>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

 <\/P>
\n

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

6. PL\/SQL \uc870\ud569 \ub370\uc774\ud130 \uc720\ud615 \uc791\uc5c5   A. \uc870\ud569 \ub370\uc774\ud130 \uc720\ud615 \u00a7\uc2a4\uce7c\ub77c \ud0c0\uc785\uacfc\ub294 \ub2ec\ub9ac \ub2e4\uc911 \uac12\uc744 \uac00\uc9c8 \uc218 \uc788\uc74c \u00a7\ubaa8\ub4e0 \uad00\ub828 \ub370\uc774\ud130\ub97c \u2018\ub2e8\uc77c \ub2e8\uc704\u2019\ub85c \ubcf4\uc720-> \uc26c\uc6b4 \uc561\uc138\uc2a4, \uc218\uc815 \u00a72\uac00\uc9c0 \uc720\ud615 \u00a71. PL\/SQL \ub808\ucf54\ub4dc \u00a72. PL\/SQL \uceec\ub809\uc158 –\uc5f0\uad00\ubc30\uc5f4(INDEX BY \ud14c\uc774\ube14) –\uc911\ucca9 \ud14c\uc774\ube14 –VARRAY   B. PL\/SQL \ub808\ucf54\ub4dc \u00a7\uad00\ub828\uc740 \uc788\uc9c0\ub9cc \uc720\uc0ac\ud558\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\ub97c \ub17c\ub9ac\uc801 \ub2e8\uc704\ub85c \ucc98\ub9ac\ud560 \ub54c […]<\/p>\n","protected":false},"author":1,"featured_media":1249,"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\/cfile2.uf.2103C94F5689340E3500B3.png?fit=796%2C83","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1248"}],"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=1248"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1248\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1249"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1248"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}