This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / Hello DXs, in Oracle, how to return only unique words (space is delimiter) from a column (which is CLOB data type)? If function is a good answer, how to achieve it? Thanks-- Note: The string could be several thousand characters in each record.
Create Table Test_Clob (Id Number(15), Test_Field Clob);
Insert Into Test_Clob (1,'This is a test test only test');
Insert Into Test_Clob (1,'Test again and again');
.
.
-- Expect result set
----------------------------
1 This is a test only
2 Test again and
.
.
-brother-pooh(Pooh哥哥);
2007-9-14
{356}
(#3931930@0)
-
one single SQL will do
-win(秋天的菠菜);
2007-9-14
(#3931933@0)
-
something like this
-win(秋天的菠菜);
2007-9-14
{567}
(#3931941@0)
-
很巧妙的办法，我在ASKTOM上看到过。如果分隔符中有多个重复的空格，还得用规则表达式处理一下。
-newkid(newkid);
2007-9-15
(#3933338@0)
-
Thank you 秋菠 :)
-brother-pooh(Pooh哥哥);
2007-9-20
(#3944898@0)
-
哪有学sql 的书或者网站啊，不是指sql语法。先谢了
-ineedjobnow(找工中);
2007-9-20
(#3945994@0)