如何定义常量，使其可以在另一个包中调用
答案:1 悬赏:30
解决时间 2021-02-15 21:13
- 提问者网友：醉归
- 2021-02-14 21:09
如何定义常量，使其可以在另一个包中调用
最佳答案
- 二级知识专家网友：萌萌哒小可爱
- 2021-02-14 22:20
SQL> create or replace package pck is
2 n constant number:=1;
3* end pck;
SQL> /
SQL> create or replace package pck1 is
2 procedure display;
3 end pck1;
4 /
Package created.
SQL> create or replace package body pck1 is
2 procedure display is
3 n number;
4 begin
5 n:=pck.n;
6 dbms_output.put_line(n);
7 end;
8 end pck1;
9 /
Package body created.
SQL> begin
2 pck1.display;
3 end;
4 /
1
PL/SQL procedure successfully completed.
2 n constant number:=1;
3* end pck;
SQL> /
SQL> create or replace package pck1 is
2 procedure display;
3 end pck1;
4 /
Package created.
SQL> create or replace package body pck1 is
2 procedure display is
3 n number;
4 begin
5 n:=pck.n;
6 dbms_output.put_line(n);
7 end;
8 end pck1;
9 /
Package body created.
SQL> begin
2 pck1.display;
3 end;
4 /
1
PL/SQL procedure successfully completed.
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯