declare
subtype t_loopcounter is number;
v_loopcounter t_loopcounter;
另外这样定义更像一个类:
Creating a Type Body Example
The following object type body implements member subprograms for rational. (PL/SQL is shown in italics.) CREATE TYPE BODY rational
IS
MAP MEMBER FUNCTION rat_to_real RETURN REAL IS
BEGIN
RETURN numerator/denominator;
END; MEMBER PROCEDURE normalize IS
gcd NUMBER := integer_operations.greatest_common_divisor
(numerator, denominator);
BEGIN
numerator := numerator/gcd;
denominator := denominator/gcd;
END; MEMBER FUNCTION plus(x rational) RETURN rational IS
r rational := rational_operations.make_rational
(numerator*x.denominator +
x.numerator*denominator,
denominator*x.denominator);
BEGIN
RETURN r;
END; END;
subtype t_loopcounter is number;
v_loopcounter t_loopcounter;
另外这样定义更像一个类:
Creating a Type Body Example
The following object type body implements member subprograms for rational. (PL/SQL is shown in italics.) CREATE TYPE BODY rational
IS
MAP MEMBER FUNCTION rat_to_real RETURN REAL IS
BEGIN
RETURN numerator/denominator;
END; MEMBER PROCEDURE normalize IS
gcd NUMBER := integer_operations.greatest_common_divisor
(numerator, denominator);
BEGIN
numerator := numerator/gcd;
denominator := denominator/gcd;
END; MEMBER FUNCTION plus(x rational) RETURN rational IS
r rational := rational_operations.make_rational
(numerator*x.denominator +
x.numerator*denominator,
denominator*x.denominator);
BEGIN
RETURN r;
END; END;
解决方案 »
- 未能加载文件或程序集“Oracle.DataAccess, Version=2.112.1.0,.....,怎么解决这个问题呢
- 求一个递归查询的写法
- oracle监听出错!
- 关于使用databaselink 时 表同名问题求解
- union all时报ORA-03113:通信通道的文件结束
- 兄弟我骨折修养中,散点分希望快快回复
- java操作oracle8i出现的问题,急!!!
- 请问oracle的安装问题
- 小弟有个问题请教诸位~~~关于存储过程
- TNS:listener failed to start a dedicated server process,怎么解决(在线等待,谢谢)
- 列的缺省值如何赋值
- 请教: DDL事件审计的问题。
f1 NUMBER,
f2 VARCHAR2(10),
f3 DATE
);
/
1、定义语法:
SUBTYPE subtype_name IS base_type [NOT NULL];
2、举例
SUBTYPE name is CHAR;
我就可以这样用了
var1 name(8);--相当于var1 char(8)