declare
subtype t_loopcounter is number;
v_loopcounter t_loopcounter;
subtype t_loopcounter is number;
v_loopcounter t_loopcounter;
解决方案 »
- oracle11g跨平台传输表空间问题
- 创建了分区表,分区已经建好了,,但是发现建好的表无法在增加分区,怎么回事?
- 表字段的复制
- 如何取得过程和函数
- oracle8i数据库系统安装是在哪儿设置字符集?
- 百分求教一个简单的触发器(在线),求两列的合计值赋给第三列
- 请问我的ORACLE数据库归档日志文件存放在哪里?
- 如何去掉某个字段中可能存在的空格 和回车键???
- OCI8i中支持哪几种外部数据类型(如:SQLT_STR,SQLT_INT,SQL_FLT)
- oracle问题,求教
- RHLinux8.0 下安装Oracle8i遇到错误!达人来帮忙!!
- 一个关于sequence的难题,高手请进!^_^ 高分相赠
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;