oracle中sql拼接两个字段的值,SQL查询连接Oracle中多行的列值

使用SQL模型子句：

SQL> select pid

2       , ltrim(sentence) sentence

3    from ( select pid

4                , seq

5                , sentence

6             from b

7            model

8                  partition by (pid)

9                  dimension by (seq)

10                  measures (descr,cast(null as varchar2(100)) as sentence)

11                  ( sentence[any] order by seq desc

12                    = descr[cv()] || ' ' || sentence[cv()+1]

13                  )

14         )

15   where seq = 1

16  /

P SENTENCE

- ---------------------------------------------------------------------------

A Have a nice day

B Nice Work.

C Yes we can do this work!

3 rows selected.

我写过这篇文章这里..如果您遵循OTN线程的链接，您将发现更多的内容，包括性能比较。