Oracle. How can I handle outer fields with IN operator and OUTER JOIN -

-

i wrote query this

select *  (select            table2.val val1,           table2.val val2,           table2.val val3,           table2.val val4,           table2.val val5,           table2.val val6,           case               when val1 null '10'              when val3 null '20'              when val5 null '30'              else '40'            end progress                  table1, table2                  table1.key = table2.key(+)           table2.cond in ('1','2','3','4','5','6') )       progress > '20'

this query not working. there's error in

,case when val1 null '10'       when val3 null '20'       when val5 null '30'       else '40' end progress

this part. error says val1 incongruence.

i can resolve if use this

from table2 tb2_1, table2 tb2_2, table3 tb2_3 tb2_1.key(+) = table1.key , tb2_2.key(+) = table1.key

declare same tables several times, but

i don't want because real query more complicated this.

is there way can distinguish outer tables this?

,case when table2[1].val null '10'       when table2[2].val null '20'       when table2[3].val null '30'       else '40' end progress

or other way. please :)

use proper explicit join syntax:

select . . . table1 left join      table2      on table1.key = table2.key ,         table2.cond in ('1','2','3','4','5','6')

simple rule: never use commas in from clause. always use explicit join syntax.


Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more