另外想问一下 我对语句进行排序为什么会报缺失右括号 (select wav.comment_text
from wfl_approve_record_v wav
where wav.instance_id =
(select max(wwi.instance_id)
from wfl_workflow_instance wwi
where wwi.document_number = y.document_number)
and exists (select 1
from wfl_workflow_deliver wwd
where wwd.recipient_id = wav.created_by
and wwd.workflow_id = wav.workflow_id)
and exists (select wwd.workflow_id
from wfl_workflow_deliver wwd
where wwd.deliver_to_id = wav.created_by
and wwd.workflow_id = wav.workflow_id)
order by wav.creation_date) text,如果将最外层的 ()text, 去掉的话是可以运行的。
from wfl_approve_record_v wav
where wav.instance_id =
(select max(wwi.instance_id)
from wfl_workflow_instance wwi
where wwi.document_number = y.document_number)
and exists (select 1
from wfl_workflow_deliver wwd
where wwd.recipient_id = wav.created_by
and wwd.workflow_id = wav.workflow_id)
and exists (select wwd.workflow_id
from wfl_workflow_deliver wwd
where wwd.deliver_to_id = wav.created_by
and wwd.workflow_id = wav.workflow_id)
order by wav.creation_date) text,如果将最外层的 ()text, 去掉的话是可以运行的。
解决方案 »
- default关键字
- 關於數據庫查詢的一個問題,請高手幫忙
- 程序或PL/SQL登录后一段时间就自动掉线了
- 取最大值的问题
- 用什么方法或工具测试oracle9i的运行性能?
- 如何统计出某个时间段每个人每天的完成量
- !!!!!初学oracle写了个触发器,执行时出现错误怎么办??
- like 'a_bcd' _只能是 b或者c或者f 能够使用类似SYBASE [b,c,f]去选择吗?
- 怎样用一个查询语句查询一个表中有几个字段?要求得出的是一个数字而不是字段名。
- create session 与 create table 权限之间的关系问题
- oracle用户列表中,PUBLIC是个什么样的账户。
- oracle 行列合计统计,请高手赐教
11g之后可以使用listagg
select listagg(comment_text,',') within group(order by creation_date) from (
select wav.comment_text,wav.creation_date
from wfl_approve_record_v wav
where wav.instance_id =
(select max(wwi.instance_id)
from wfl_workflow_instance wwi
where wwi.document_number = y.document_number)
and exists (select 1
from wfl_workflow_deliver wwd
where wwd.recipient_id = wav.created_by
and wwd.workflow_id = wav.workflow_id)
and exists (select wwd.workflow_id
from wfl_workflow_deliver wwd
where wwd.deliver_to_id = wav.created_by
and wwd.workflow_id = wav.workflow_id)
)