##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.

ITPub博客

oracle plsql(三）_type_cursor

最新文章