SQL pivot query in Oracle -

-

i have table this:

name----address----type----value       finland    color    120       finland    wage     500

what want show color , wage values columns:

name----address----color----wage       finland     120     500 

select *   (select name, address, type, value           table) pivot  (sum(value)  (type) in ('color', 'wage'));

Comments

Post a Comment

Popular posts from this blog

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

c++11 - Intel compiler and "cannot have an in-class initializer" when using constexpr -

-
the following test program compiles , runs fine g++. intel icpc (14.0.2) compile , run if use explicit type double instead of template. template version icpc produces error: icpc -g -o2 -i. -std=c++0x -c main.cc -o main.o main.cc(10): error: member of type "const t [9]" cannot have in-class initializer static constexpr t dx_[9] = { test code template<typename t> class myclass { public: static constexpr t dx_[9] = { 1.5, 2.0, -0.5, -0.5, 0.0, 0.5, 0.5, -2.0, -1.5 }; }; template<typename t> constexpr t myclass<t>::dx_[9]; int main(int argc, char *argv[]) { return 0; } // main why receiving error "cannot have in-class initializer" when using constexpr ? this bug of intel compiler, submitted intel , fixed in future versions. also see multiple constexpr bugs , sfinae bug intel c++ compiler 15 , method constexpr bug c++ compiler 15 on intel forums.
Read more

python - get cookie expiry time using the requests library -

-
i trying expiry time of specific cookie retrieve server as: s = requests.session() r = s.get("http://localhost/test") r.cookies this list cookies sent server (i 2 cookies) as: <<class 'requests.cookies.requestscookiejar'>[<cookie phpsessid=cusa6hbtb85li8po argcgev221 localhost.local/>, <cookie websecu=f localhost.local/test>]> when do: r.cookies.keys i get: <bound method requestscookiejar.items of <<class 'requests.cookies.requestscooki ejar'>[cookie(version=0, name='phpsessid', value='30tg9vn9376kmh60ana2essfi3', p ort=none, port_specified=false, domain='localhost.local', domain_specified=false , domain_initial_dot=false, path='/', path_specified=true, secure=false, expires =none, discard=true, comment=none, comment_url=none, rest={}, rfc2109=false), co okie(version=0, name='websecu', value='f', port=none, port_specified=false, doma in='localhost.local...
Read more