Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Select statement in from clause

Select statement in from clause

From: Proffesional newbie <mobieladres_at_hotmail.com>
Date: 18 Sep 2002 01:06:22 -0700
Message-ID: <46b4a824.0209180006.640be597@posting.google.com>


Hi i found the next select statement and i was wondering what this select statement in the from clause does ? It is the first time i see this.

Thnx

Dennis

==================SQL===========================

select	rpad(nvl(header.bill_number,' '),8)||
	nvl(substr(to_char(header.customer_number,'0999'),2),'    ')||
	rpad(nvl(header.title,' '),50)||
	nvl(to_char(header.date,'ddmmyy'),'      ')||
	substr(to_char((nvl(times.manuf_time, 0) * 10000), '0999999'), 2)||
	substr(to_char((nvl(line.aantal, 0) * 1000000), '0999999'), 2)||
	rpad(substr(nvl(customer.customer_name, ' '), 1, 30), 30)||
        rpad(substr(nvl(header.pcode, ' '),1,10), 10)
from	bills header

, detail line
, ( select a.bill_number
, (nvl(sum(b.unit_time), 0)/60)*1.1 manuf_time from detail a , article b where a.part_number = b.part_number group by a.bill_number ) times
, customer
where header.bill_number = times.bill_number(+) and header.bill_number = line.bill_number(+) and line.part_number = '5000' and header.customer_number = customer.customer_number(+) and not exists ( select 1 from bills_sended sended where sended.bill_number = header.bill_number );
Received on Wed Sep 18 2002 - 03:06:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US