Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!zaphod.mps.ohio-state.edu!samsung!aplcen!haven!vrdxhq!dev!jkrueger From: jkrueger@dev.dtic.dla.mil (Jonathan Krueger) Newsgroups: comp.databases Subject: Re: variable record length Keywords: RDBMS, variable record length, images Message-ID: <3606@dev.dtic.dla.mil> Date: 7 Feb 90 15:50:49 GMT References: <4qx80zz@unify.uucp> <1990Feb5.23504 Distribution: usa Organization: Defense Technical Information Center (DTIC), Alexandria VA Lines: 49 corpspt@oracle.com ((Owner) Mary Winslow) writes: >The Oracle LONG ... can hold values up to 64k in length. Last I checked, Oracle LONGs could not be selected on, pattern matched, indexed, or sorted on. Is this still the case? If so, this isn't a data type: it's persistent shared storage. If not, please show how Oracle would form the followinq query: Given a table like (deja vu, anyone?) +-----+ | emp | name hiredate resume +-----+---------+-------------------------------------------------+ | Stevans | 20 Sept 1989 | 1975 to 1978: wrote database ... | +---------+-------------------------------------------------+ would the select syntax look like select name from emp where fulltext(resume, "UNIX") = 1 Or what would it look like? Also, please explain how indexing and storage structures would prevent exhaustive table scans. This will help us understand how Oracle customers can use their LONG and LONG RAW data types. -- Jon -- Jonathan Krueger jkrueger.dtic.dla.mil uunet!dgis!jkrueger Isn't it interesting that the first thing you do with your color bitmapped window system on a network is emulate an ASR33? > I have submitted an enhancement request to allow declarations without a > size, which would imply the inherent maximum allowed for that datatype. > (In case jkrueger@dgis.dtic.dla.mil (Jon) ever has to use Oracle :-)) I would be happy to use Oracle for tasks it's suited to. Your enhancement adds nothing to Oracle's suitability for highly textual applications. It's trivial for the database designer to declare all Oracle colums to the maximum size allowed. That's not variable length columns, nor support for same, and therefore its automation is not a useful addition to your product. -- Jon -- Jonathan Krueger jkrueger.dtic.dla.mil uunet!dgis!jkrueger Isn't it interesting that the first thing you do with your color bitmapped window system on a network is emulate an ASR33?