select *results in one row returned.
where ik = '100602360'
some possible reasons (I suppose kt_stamm_20072_v isSorry, I forgot to say.
a) kt_stamm_20072_v reads data from a globalNot that I can see it. It seems to read from a number of other tables and views.
temporary table, which holds different data for
b) kt_stamm_20072_v reads data from a materializedI don't think so.
c) you connect with different usersAlways the same user.
d) SQL*Developer sometimes shows strange behaviour ifI always put the semicolon. Also it seems to be an SQL*Developer-Golden-SQuirreL-versus-SQL*Plus-Toad-problem.
you omit the semicolon at the end of a statement
e) your view has where-clauses which are timeThey shouldn't and the data is changing very slowly. Also there doesn't seem to be a time dependency but a tool dependency. All sessions were newly started. The effect was seen yesterday the first time (before that no one checked so it might have been there) and is still there today. I rebooted my computer since yesterday.