Deleting spatial data only deletes one row
I have the following query that does not work correctly:
DELETE FROM terrain WHERE MBRContains(PolygonFromText('POLYGON((0 0, 1000 0, 1000 1000, 0 1000, 0 0))'),object)
object has a datatype of POLYGON.
The problem is that there are several rows that meet the WHERE clause of the delete statement, but only one row gets deleted (they all should!!). Any clues on to what I am doing wrong? TIA.
Subject
Views
Written By
Posted
Deleting spatial data only deletes one row
3664
January 10, 2005 01:35PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.