Reputation
217
Top tag
Next privilege 250 Rep.
View close votes
Badges
6 12
Impact
~21k people reached

  • 0 posts edited
  • 0 helpful flags
  • 13 votes cast
Apr
18
awarded  Notable Question
Mar
4
comment Oracle from_tz with Russian timezones shifts the input timestamp?
I'm on filename=timezlrg_21.dat version=21
Mar
3
comment Oracle from_tz with Russian timezones shifts the input timestamp?
I get 11:00 for both 28 and 29 MAR in your example. Just replicated it on 12c as well :(
Mar
3
asked Oracle from_tz with Russian timezones shifts the input timestamp?
Nov
5
awarded  Notable Question
Jan
22
comment How can I use Oracle's CONNECT BY PRIOR to only get specific revisions of hierarchical records?
If I explicitly set the timestamp in the 'START WITH' clause (START WITH "ITEMNNAME"="item1" AND TIMESTAMP=?), the CONNECT BY clause still returns multiple rows for each related. If I could somehow group these by distinct(ITEMNAME) and return the record foreach ITEMNAME with the largest timestamp below a certain value, that'd probably be what I need. I've no idea how to do that though.
Jan
22
awarded  Editor
Jan
22
comment How can I use Oracle's CONNECT BY PRIOR to only get specific revisions of hierarchical records?
I've updated it to hopefully be a bit clearer. The query is asking at a specific point in time, what was the latest view on the hierarchy. So on the first query, the latest value for item1 is row #1, and that links to the item2, the latest value at that time was row #2.
Jan
22
revised How can I use Oracle's CONNECT BY PRIOR to only get specific revisions of hierarchical records?
added 230 characters in body
Jan
22
asked How can I use Oracle's CONNECT BY PRIOR to only get specific revisions of hierarchical records?
Nov
21
awarded  Notable Question
Aug
14
awarded  Yearling
Aug
13
awarded  Notable Question
Jul
2
awarded  Curious
Jun
25
awarded  Popular Question
Jun
5
awarded  Popular Question
Apr
24
awarded  Notable Question
Apr
1
awarded  Popular Question
Mar
19
awarded  Popular Question
Mar
17
awarded  Popular Question