Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table t (id, memo) as
    select 1, 'aaa'  from dual union all
    select 2, 'bbbb' from dual
2 rows affected

create or replace type o force as object (len int, val varchar2(16))
/
create or replace type coll as table of o
/
create or replace function f (val varchar2) return o is
begin
    return o (length (val), substr (val, 1, 16));
end;
/
create or replace view v as
    select * from t, coll (f(t.memo))
select * from v


ID
MEMO
LEN
VAL


1
aaa
3
aaa

2
bbbb
4
bbbb