r-onlineinformation.blogspot.com Tips for running queries on Oracle We encourage the use of PostgreSQL for the labs, to expose students to an excellent open source database. However, if your syllabus forces you to use Oracle (and all participants at your remote centre are also from universities where they are forced to use Oracle), you can do assignments on Oracle. Our model solutions will often give syntax errors on Oracle due to non-support for some SQL features in Oracle. Below are some tips on how you can rewrite the queries to work on Oracle. Oracle SQL Tips: non-standard features, and limitations The following issues are for Oracle 10, and may or may not apply to later versions of Oracle. Oracle does not support the as clause, except as part of the "with" statement. In all other cases, just use the same syntax without the "as" keyword, and things should work. To use a single quote in a string, use two consecutive single qu...
Comments