Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!logbridge.uoregon.edu!snoopy.risq.qc.ca!News.Dal.Ca!coranto.ucs.mun.ca!not-for-mail From: Tim Marshall Newsgroups: comp.databases.oracle.server Subject: Re: SQL Approach, Multiple Tables, UNION? Date: Tue, 09 Sep 2003 13:58:05 -0230 Organization: Memorial University of Newfoundland Lines: 24 Message-ID: <3F5DFF95.4EB375E3@Gunner.Sabot.Spam.On.Loaded.FIRE> References: <3F5AD100.6A9D42@Gunner.Sabot.Spam.On.Loaded.FIRE> <1062948852.128059@yasure> NNTP-Posting-Host: fm-zhukov2.facman.mun.ca Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: coranto.ucs.mun.ca 1063124886 12286 134.153.228.205 (9 Sep 2003 16:28:06 GMT) X-Complaints-To: usenet@coranto.ucs.mun.ca NNTP-Posting-Date: Tue, 9 Sep 2003 16:28:06 +0000 (UTC) X-Mailer: Mozilla 4.77 [en] (Win95; U) X-Accept-Language: en Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242703 John Russell wrote: > > I think you'll have an easier time reading up on "inline views". :-) > "In-line views" gives no hits in a doc search, but "inline views" > turns up some matches: Now I understand some of the challenges the folks who are working on voice input are facing! > > http://otn.oracle.com/pls/db92/db92.drilldown?remark=&word=inline+views&book=&preference= Thanks, I'll poke around here. Essentially, what I've got now, is a basic structure with 6 in-line (er, inline) views. Added to that, I have three other tables for cost transactions (parts, labour, other) that I'll have to add. It seems like an awful lot, but I don't know. Also, depending on criteria the user selects, those 6 inlines can be knocked down to one, if say, the user specifies "work orders with equipment". But most of the time, the users won't specify that. -- Tim - http://www.ucs.mun.ca/~tmarshal/ ^o< /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake /^^ "Want some?" - Ditto