关于alter type ....谢谢! 对于以上Alter type 应该是正确的但不知道为什么出现了错误请否指正? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 CREATE TYPE data_t AS OBJECT ( year NUMBER, MEMBER FUNCTION prod(invent NUMBER) RETURN NUMBER ); CREATE TYPE BODY data_t IS MEMBER FUNCTION prod (invent NUMBER) RETURN NUMBER IS BEGIN RETURN (year + invent); END; END; ALTER TYPE data_t REPLACE AS OBJECT ( year NUMBER, MEMBER FUNCTION prod(invent NUMBER) RETURN NUMBER, MEMBER FUNCTION qtr(der_qtr DATE) RETURN CHAR ); alter type那有add方法。 SQL语句哪个快? 如何使用oracle的普通连接 请问oracle8i存储过程是否支持将一个数据集作为参数进行传递 关于查询结果排序的问题,进来帮帮忙啊! 为什么无法安装 一个sql语句怎么写? 初学者请教 in 查询问题 问一个case相关的SQL问题 求一游標!對了馬上接帖 Oracle9i中如何能同时导出多个表的sql脚本,用第三方工具也成,最好oracle提供? Oracle8.17 For Solaris 表空间问题
( year NUMBER,
MEMBER FUNCTION prod(invent NUMBER) RETURN NUMBER
);
CREATE TYPE BODY data_t IS
MEMBER FUNCTION prod (invent NUMBER) RETURN NUMBER IS
BEGIN
RETURN (year + invent);
END;
END;
ALTER TYPE data_t REPLACE AS OBJECT
( year NUMBER,
MEMBER FUNCTION prod(invent NUMBER) RETURN NUMBER,
MEMBER FUNCTION qtr(der_qtr DATE) RETURN CHAR
);
alter type那有add方法。