Article:		Using the New MODEL Clause in Oracle Database 10g
Subject:		not bad.. not bad !!
Date:		2004-08-18 09:57:29
From:		Thesaint
i prefer open source databases... too much crap with Oracle. This new clause Model clause is a step in the right direction. this gives a needed boost to sql. I like the iterative capabilites and would never have thought you can compute the Fibonacci sequence in sql. very nice. what can i do to avoid the core dumps?

Showing messages 1 through 1 of 1.

• not bad.. not bad !!
  2004-08-19 20:10:33  Anthony Molinaro | [View]
  
  
  The only time i ran into core dumps is when i referenced all_objects in the model clause.
  I also cored if i tried to use a correlated subquery with a reference model. It's noted in the docs you can't use correlated subqueries in for loop iteration, but you can't use it in reference models either.
  I'm sure this will be cleaned up and the correct error message produced by the next version of 10g.