Smartsite Documentatie > Advanced > Concept > Data Layer > Query Preparser

Query Preparser

Release 1.2 - ...

The Query Preparser attempts to convert SqlServer queries to Oracle queries and the other way around.
The Query Preparser isn't able to convert all possible sql queries but it can convert many small common
differences. This helps when you are having problems executing queries in a cross dbms site.

The Query Preparser executes the following rules when executing an sql query on Oracle:

  1. Removes "dbo."
  2. Converts "isnull(" into "nvl("
  3. Converts "len(" into "length("
  4. Converts "char(" into "chr("
  5. Converts "substring(" into "substr("
  6. Converts "newid()" into "sys_guid()"
  7. Converts "getdate()" into "sysdate()"
  8. Converts string concatenation using + into string concatenation using ||
  9. Converts "as [<name>]" into "as "name""
  10. Converts "top n" into "where rownum < n"
  11. Converts "table(fn_recursechildren(...))" into "fn_recursechildren(...)"
  12. Converts "table(fn_aimdependencies(...))" into "fn_aimdependencies(...)"

 

The Query Preparser executes the following rules when executing an sql query on SqlServer:

  1. Remove "from dual"
  2. Converts "where rownum < n" into "top n"
Advanced