oracle plsql(三）_type_cursor

##plsql內部rowtype與type可以引用表列屬性，但又可以獨立於此；

 

SQL> r
  1  declare
  2  dept_rec dept%rowtype;
  3  cursor c1 is select deptno,dname from dept;
  4  dept_rec2 c1%rowtype;
  5  begin
  6  select * into dept_rec from dept where deptno=10;
  7  if dept_rec.deptno=10 then
  8  dept_rec.loc:='new di';  ##說明plsql的變數值顯示是表的值，但表值沒有變化
  9  dbms_output.put_line(dept_rec.loc);
 10  end if;
 11* end;
new di

PL/SQL procedure successfully completed.

SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        50 dba            beijing
        60 developer      xianan
        70 manager        hainan
        90 leader         weinan
       100 farmer         fuping
       120 worker         guangxi
       888 sex            beijing
        77                weinan
       778                fuping
      1120                guangxi
      2888                beijing

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

15 rows selected.