Thursday, February 25, 2010

UPDATE: DBLP Practice Queries

The DBLP practice queries have been updated with minor syntax fixes to support the Oracle SQL dialect. In particular, because of the two non-standard features below:

1. Oracle does not support the keyword AS in FROM for aliasing, but you can specify aliases without AS.


2. The set difference relational operator in Oracle is MINUS rather than EXCEPT.

For other non-standard features in Oracle see:

http://infolab.stanford.edu/~ullman/fcdb/oracle/or-nonstandard.html

No comments:

Post a Comment