Larger Resultset from View

[#1]

Hello,

I created a view that has a record count of 3 mio rows.

When loading it to qlik sense it fetches about 11 mio rows.

The used code is quite simple - it's just a SELECT id, date FROM my_view;

I really do not understand this - why does it happen?

any ideas, suggestions?

[maxgro · Accepted solution]

a

SELECT * from owner.table

should return the same rows in every tool (sense, sqlplus, sql developer, etc....)

Check you're using the same database and the same oracle user