113 reputation
6
bio website
location Germany
age 41
visits member for 2 years, 8 months
seen Apr 11 at 16:24

Feb
6
awarded  Citizen Patrol
Aug
11
awarded  Commentator
Aug
11
comment Alternatives to MySQL Workbench
IP tunneling is not an application issue, you'd do that separate on the system. Some apps include it for convenience, but it's not necessary at all, it's completely different issue. You can start ssh forwarding with a single line in a shell, and then tell the app to connect to the forwarded local port (on localhost) instead of the remote ip and port. Howtos are available by googling...
Aug
9
awarded  Supporter
Aug
9
awarded  Scholar
Aug
9
comment How do I group results in batches of consecutive rows with the same 'module'
Works - marked as solution. Too bad this isn't nearly as simple as the Unix text pipe solution...
Aug
9
accepted How do I group results in batches of consecutive rows with the same 'module'
Aug
9
revised How do I group results in batches of consecutive rows with the same 'module'
added 253 characters in body
Aug
9
comment How do I group results in batches of consecutive rows with the same 'module'
I must say if it gets even more complicated I feel you should get paid, but unfortunately it's more educational than necessary - I just have to let my brain do the filtering of the superfluous lines ;)... or I use a text-tool, e.g. "awk", or pipe the text result through "uniq" on the command line...
Aug
9
comment How do I group results in batches of consecutive rows with the same 'module'
The EDIT: getting closer... I get [set_option_value,get_rights_usecase,set_option_value,get_rights_usecase,get_fun‌​_AppOptionsSingleVal,get_rights_usecase], what it should be see my example result above.
Aug
9
revised How do I group results in batches of consecutive rows with the same 'module'
added 143 characters in body
Aug
9
comment How do I group results in batches of consecutive rows with the same 'module'
I am looking for the modules IN ORDER without duplicate rows! As I said :) So it does not matter if you give me the first, last, whatever row in a date range - it is the same module (text). I just added the desired output for the example under the EDIT as well, hope that helps.
Aug
9
revised How do I group results in batches of consecutive rows with the same 'module'
added 198 characters in body
Aug
9
comment How do I group results in batches of consecutive rows with the same 'module'
The examnple I gave is sufficient. Instead of "pdate" you could also use "id", an auto-incremented (sequence.nextval) column. Also see my EDIT.
Aug
9
awarded  Student
Aug
9
awarded  Editor
Aug
9
revised How do I group results in batches of consecutive rows with the same 'module'
added 751 characters in body
Aug
9
revised How do I group results in batches of consecutive rows with the same 'module'
added 751 characters in body
Aug
9
comment How do I group results in batches of consecutive rows with the same 'module'
Result: Error code 904, SQL state 42000: ORA-00904: "C"."PDATE": invalid identifier - but that's because you took "L" for "C" after the join... :) And no, I get a different sequence compared to when I look at the raw data (and let my brain do the filtering/grouping)
Aug
9
comment How do I group results in batches of consecutive rows with the same 'module'
You are right, "group by" would be a better explanation of what I want. Anyway, this doesn't change the problem.