In an "Unconference" session at Oracle Open World, Laurent Schneider did a session about the SQL Model Clause. He posted his demonstration script on his site here.
If you have been reading my SQL Model Clause Tutorial, part one and SQL Model Clause Tutorial, part two, then I can recommend you to run this script as well and see some interesting queries. You only need the EMP and DEPT tables. A nice catch for me was to have a constant in the PARTITION BY clause.
Friday, November 16, 2007
SQL Model Unconference
Posted by Rob van Wijk at 11:30 PM
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment