andrucz

Brazil

Age: 23

2d
awarded Supporter
2d
comment Left join expression and amount of rows returned by Oracle
I've tested in Oracle 10 and 11. I meant that one row should be returned because where clause t1.Id = 1 match one record from table A. Since left join expression doesn't match a record from table B, t2.Description should be printed null.
Nov
21
revised Left join expression and amount of rows returned by Oracle
edited tags
Nov
21
asked Left join expression and amount of rows returned by Oracle
Sep
23
awarded Popular Question
May
18
awarded Scholar
May
18
accepted Dynamic XML tags and JAXB
May
18
comment Dynamic XML tags and JAXB
Yes, I understand. That's not the better way to represent that kind of values. Unfortunately, that XML is returned by a REST web service published by another company. I can't modify the schema, but I will suggest it to them. Today, my implementation iterates over all the document tree and handles the values manually. Thanks for your help! :)
May
17
comment Dynamic XML tags and JAXB
Thanks, David. But this way I would have to add Element objects to List any. For reusability purposes, I think it would be better if I could create a class ComplementarField, for example, with attributes ordinal (int) and value (String). There is a way to deserialize complementN to a ComplementarField instance and add it to the list any?
May
17
awarded Analytical
May
17
awarded Student
May
17
asked Dynamic XML tags and JAXB