create or replace function rs_rsm_school(
hansvar,hanstable
)
return varchar(2000)
is
berbig varchar(2000);
begin
select berbig=berbig+','+ hansvar from hanstable
return(berbig);
end rs_rsm_school;帮我看看这儿哪儿错了hansvar是字段名,hanstable是表名,我就想在视图中把多条记录合成一个字段中,我菜鸟
oracle,toad
hansvar,hanstable
)
return varchar(2000)
is
berbig varchar(2000);
begin
select berbig=berbig+','+ hansvar from hanstable
return(berbig);
end rs_rsm_school;帮我看看这儿哪儿错了hansvar是字段名,hanstable是表名,我就想在视图中把多条记录合成一个字段中,我菜鸟
oracle,toad
解决方案 »
- 集合数据类型请教?
- 问题1:请问把SESSION KILL 掉之后,而CPU的利用并没有被释放,怎么做能把CPU给释放掉? 问题2;这里有个SQL文很慢谁能帮我找找原因?很急,在线
- Oracle 收费?
- 如何从cmd里输入参数
- 关于oracel在储存过程中能否用大的回滚段的问题!
- 修改表自動增量
- 我如果不使用to_date函数使用什么字符格式可以insert到一个日期型字段中?
- oracle错误代码ora-01013用户取消操作是怎么回事?
- 求助:关于授予用户权限问题
- 索引问题
- 在oracle 10g 中修改了SYSMAN用户的密码后, 莫名被锁定!状态为locked(timed),如何解锁?
- 用exp和imp导出导入图象导入不成功
hansvar in varchar,hanstable in varchar
)
return varchar2(2000)
is
berbig varchar2(2000);
begin
select berbig=berbig+','+ hansvar from hanstable
return(berbig);
end rs_rsm_school;
returns varchar(8000)
as
begin
declare @S varchar(8000)
set @S = ''
select @S = @S + ',' + SCHOOL from M_RSM_EDUCATION where RESUME_ID = @handsvar
select @S = right(@S,len(@S)-1)
return @S
end
go
我顶,在SQL*Plus中老是提示编译错误,当然也查不出来,查询的时候提示无效,应该是没建起吧,我刚刚毕业,大学根本没深入到自定义函数这块,哪位大哥帮解决一下select getstr(1) as 结果 from M_RSM_EDUCATION
hansvar in varchar,hanstable in varchar
)
return varchar2(2000)
is
berbig varchar2(2000);
begin
select berbig=berbig+', hansvar' from hanstable
return(berbig);
end rs_rsm_school;
returns varchar(8000)
as
begin
declare @S varchar(8000)
set @S = ''
select @S = @S + ', SCHOOL' from M_RSM_EDUCATION where RESUME_ID = @handsvar
select @S = right(@S,len(@S)-1)
return @S
end
go
but in oracle the union should be '||'