Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!aramis.rutgers.edu!paul.rutgers.edu!yes.rutgers.edu!emuleomo From: emuleomo@yes.rutgers.edu (Emuleomo) Newsgroups: comp.databases Subject: Re: Oracle: Previous Record Message-ID: Date: 23 Jul 89 00:47:31 GMT References: <3900001@tdpvax> <20532@cup.portal.com> Organization: Rutgers Univ., New Brunswick, N.J. Lines: 19 In article <20532@cup.portal.com> George "Bron" Faison writes... > Because Oracle is a relational and SQL oriented database >which means you should think *sets* not record-at-a-time! >Previous record has no valid meaning in a truly relational system >where by definition physical ordering is irrelevant. If you are thinking of SETS alone, then why ever use a CURSOR?? Besides, there is NO fundamental difference between FETCH NEXT and FETCH PREVIOUS!. I hear ANSI is considering including a FETCH PREVIOUS command in SQL. That would be great! (although Informix already has it). Emuleomo O.O. (emuleomo@yes.rutgers.edu) -- ** Research is what I'm doing when I dont know what I'm doing! **