sql - Replacing Strings in Oracle 8i Query -

-

i've got table in oracle 8i

value  | timestamp kkq    | 10:00 kvkk   | 11:00 kmpe   | 12:00 ppkkpe | 13:00

and need replace kv v, km m, pe r ,pp n , p l when querying these values.

what's best way it? problem see can have combination of strings in value column... values can have there are: kk, q, kv, v, km, m, pe, r, pp, n, p, l.

select    replace(   replace(   replace(   replace(<input>,      'kv', 'v'),     'km', 'm'),     'pe', 'r'),     'pp', 'n')   ....

Comments

Post a Comment

Popular posts from this blog

rest - Spring boot: Request method 'PUT' not supported -

-
i getting request method 'put' not supported error on hitting put method on restful api upload file. following information uploaded ticket. client log restcontroller spring boot app config tomcat log pom.xml 1. client log $ curl -x put -t "/cygdrive/c/a/documents/test.pptx" http://localhost:8080/piranha-storage-service/buckets/gnaval.bucket1/test.pptx <html><head><title>apache tomcat/7.0.52 - error report</title><style><!--h1 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:22px;} h2 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:16px;} h3 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:14px;} body {font-family:tahoma,arial,sans-serif;color:black;background-color:white;} b {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;} p {font-family:tahoma,arial,sans-serif;background:white;co...
Read more

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp...
Read more

symfony - imagine_filter() not generating the correct url in LiipImagineBundle -

-
i think there bug in bundle liipimaginebundle. explain: here new config of bundle: liip_imagine: resolvers: default: web_path: web_root: %kernel.root_dir%/../web/img # %kernel.root_dir%/../web/img folder filtered images created! cache_prefix: media/cache # media/cache prefix of folder cached images created filter_sets: cache: ~ my_thumb: quality: 75 filters: thumbnail: { size: [120, 90], mode: outbound } this twig part displaying image: {# way filtered image not created!#} <img src="{{ 'img/test.jpg' | imagine_filter('my_thumb') }}" /> {# way, filted images created. asset() must used. #} <img src="{{ asset('img/test.jpg' | imagine_filter('my_thumb')) }}" /> the generated link of image not correct! in fact, obtained link is: http://localhost/media/cache...
Read more