I have an issue with a view.
When i am executing a view
SELECT DISTINCT code FROM v_payroll; ------ output giving 4 rows
select distinct code from v_payroll; ------- ouput giving only 1 row!!!!!!!!!!!!
The only change i did for this statement was caps to small letters.
This view is a simple view which is actually using one table ( select colum1,coul2 from table)
Why the same statement showing different output jsut by changing capital to small letters as shown above.
Is there any solution for this
Please help its very urgent.... I am using 10G RAC config. with 2 nodes.