sql - How to remove space from CLOBs in Oracle? -


i have problems removing space clob column in oracle. have tried use clob format , trim in sql space still there. field using string text. don't want space in text. knows how fix this?

this sql:

select distinct   upper(ks.nama) bpmnama,   trim(upper(nvl(dbms_lob.substr(ks.sekatan, 4000, 1),'tiada'))) sekatnama,   upper(ks.nama) daerahnama,   upper(ks.nama) gunatanah   guna_tanah ks

for example:

sekatnama

tanah ini tidak boleh di pindahmilik, disewa atau dipajak

kecuali dengan kebenaran pihak berkuasa negeri. sekatan

kepentingan ini dikecualikan kepada pembeli pertama.

how remove space eventhough put trim?

use regexp_replace(ks.sekatan, '[[:space:]]',null)

please refer link:

http://docs.oracle.com/cd/b19306_01/server.102/b14200/sql_elements001.htm

... ...however, following statement not supported because dbms_lob.substr returns lob:

create table tab select dbms_lob.substr(clob_col) tab@dbs2;

...

you cannot specify lob columns in order clause of query, or in group clause of query or in aggregate function.

you cannot specify lob column in select... distinct or select... unique statement or in join. however, can specify lob attribute of object type column in select... distinct statement or in query uses union or minus set operator if column's object type has map or order function defined on it. .. (hope these helps).. thanks


Comments

Post a Comment

Popular posts from this blog

linux - xterm copying to CLIPBOARD using copy-selection causes automatic updating of CLIPBOARD upon mouse selection -

i've tried various ways coerce xterm (versions 285 , 292) copy selection clipboard clipboard whenever press ctrl-shift-c. promising way far has been, in ~/.xresources, put this: xterm*vt100.translations: #override \ ctrl shift <keypress> c: copy-selection(clipboard) \n\ ctrl shift <keypress> v: insert-selection(clipboard) ctrl-shift-v works perfectly, copying has nuance... if restart xterm, highlighting text puts things in primary clipboard; expected, proper, default behavior. if hit ctrl-shift-c, copies current selection clipboard clipboard. the bug, however, if highlight text after first time pressed ctrl-shift-c, you'll see highlighting copies both primary and clipboard. cannot figure out how stop xterm updating clipboard upon selection... , doesn't make sense me in first place. i said, @ specific point in time, copy selection clipboard... yet starts updating automatically upon selection after doing once... anyone have workaround...
Read more

c++ - qgraphicsview horizontal scrolling always has a vertical delta -

Image
i've subclassed qgraphicsview custom canvas used in cad application. i've reimplemented qgraphicsview::wheelevent check keyboard modifiers control key and, if control key pressed, zoom. i'm trying implement horizontal scroll when user holds shift , uses wheel. the problem i'm having horizontal scrolling always scrolls 0.279. not huge problem, hugely annoying , points else being wrong. so, here questions: is right way implement horizontal scrolling? if not, is? how eliminate delta of 0.279? thanks in advance. code , sample output below void myview::zoom(int delta) { double factor = pow(1.2, delta/abs(delta)); this->scale(factor, factor); } void myview::scrollhorizontal(int level) { qpointf center = maptoscene(viewport()->rect().center()); qdebug() << "center: " << center.x() << ", " << center.y(); centeron(qpointf(center.x() - level, center.y())); } void myview::wheelevent(qwheeleve...
Read more