我有一个类型叫做“budget”,定义如下:
create type budget as object (
year number,
amount number,
member function left_over (year in number) return number
)
正文:
create type body budget as
member function left_over(year in number) return number is
begin
return amount;
end left_over;
end;
一个对象表
create table budget_table of budget;
如何使用成员函数返回数量?类似这样的代码:
select b.left_over(2010) from budget_table b;
谢谢