All Questions

Tagged with
Filter by
Sorted by
Tagged with
1
vote
1answer
43 views

Oracle database - get two rows (A,B) for every (COD) row

I have a Oracle database and a variable that can have a value for A and a value for B like in this example: cod cat v1 v2 v3 123 A 1 10 11 123 B 0 0 0 111 A 2 3 ...
0
votes
1answer
311 views

Joining Oracle tables with 2 strings to be oa a single row (in a distinct SQL filter)

I have an Oracle Database and if I fire that SQL: SELECT distinct RAP.ID_PL, SES_RAP.AN, RAP.DENUMIRE, A3T2.COD_DESEU, A3T2.TIP_AMB, A3T2.COD_REC, A3T2.COD_VAL FROM chest cht INNER JOIN ...
1
vote
1answer
78 views

oracle database filter with full outer join and coalesce intersect

in a Oracle Database if I "shoot" SELECT RAP.IDPL, C41.TIP_COD_DESEU AS CD41,C41.STOC_VAL AS CANT41, C42.TIP_COD_DESEU AS CD42,C42.STOC_VAL AS CANT42, C43.TIP_COD_DESEU AS CD43,C43....
0
votes
1answer
2k views

joining tables with full outer join and… COALESCE?

I have a few tables in an Oracle database linked by id - fk_id, if I do: select RAP.ID_PCT_LUCRU,SES_RAP.AN, TIS.CANT as c1,'R12' as modc1, TIT.CANT as c2,'D13' as modc2, TIMB....