Before I started to do the work,I was afraid that I would work tired because I don't believe E's analysis.

  The work transfer SQL syntax from Sql server to Oracle looks very simple at apparently,but in fact it should be treated seriously.When I test the system which inner Sql transfered ,I find a lot of bugs because the developer's careless.Some functions of program couldn't run,the system shutdown because of the sql's errors.

 If somebody want to translate the sql server to oracle,he should notice not only the difference between sql server and oracle,but also should take this difference in heart:sql server isn't case sensitive while oracle case sensitive.When I execute the test,I test a lot of bugs because this difference.But there is no difference whether tablename and columnname is upper case or not.The developer ignore this  difference lead to a lot of bugs and my test's delay.I should remember the lesson.