Error Sequence with Query Execution

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
        
  1.         Table does not exist
  2.         Order by 
  3.         Having 
  4.         Where 
  5.         Group by
  6.         Select columns

No comments:

Post a Comment