For E.g. you are executing a query so below are the list of error sequence while an oracle will give for any invalid value at each location
for e.g. I have a query where nothing exist and I can replace each error with correct value and try to find the sequence of errors on Oracle when syntax is correct
Sample Query where not Column / Table exists
Select element1
from testtable
where element1 =2
group by element1
having count(element1)>1
order by element1 desc
- Table does not exist
- Order by
- Having
- Where
- Group by
- Select columns
No comments:
Post a Comment