Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!ncar!ames!sgi!wdl1!mitchell From: mitchell@wdl1.UUCP (Jo Mitchell) Newsgroups: comp.databases Subject: Re: Entity Supertypes/Subtypes & SQL Message-ID: <3560037@wdl1.UUCP> Date: 6 Apr 89 17:04:28 GMT References: <1011@cetc.Wichita.NCR.COM> Lines: 5 Why are you considering one query rather than using cursors and doing other queries based on the subsequent result? I haven't used Oracle in three years but that's what we use to do for this type of thing, I believe.