after entering the following query,
select * from paydetl where party = '123' and
bill_no not in(select distinct bill_no from gkout where
party = '123')
it gives the error
ora-00600 internal error code arguments
[srsale_2], [0], [45], [], [], [], [], []
no rows selected.
here 'gkout' is the valid view.
paydetl is the table.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Reply With Quote
Originally Posted by madhugp
Bookmarks