SQL need help

Hi, I have two tables 1. ALL_CUSTOMER CustNo: 1 to 100 OtherDetail: bla bla bla 2. ORDER CustNo TotalOrder DateOrder I want to display like this CustomerNo 1Total Order For This month = 101 or CustomerNo 1 Total Order For This month = 0 My SQL statement is

RE: SQL need help

select 'CustomerNo '||a.custno||' Total Order for this month = '||nvl(c.totalorder,0) from all_customer a, (SELECT b.custno as custno, sum(b.totalorder) as totalorder from orders b group by b.custno,to_char(b.dateorder,'mm') having

Re: SQL need help

Outer join? Guang On Thu, 3 Jul 2003, Sinardy Xing wrote: Hi, I have two tables 1. ALL_CUSTOMER CustNo: 1 to 100 OtherDetail: bla bla bla 2. ORDER CustNo TotalOrder DateOrder I want to display like this CustomerNo 1Total Order For This month = 101

SQL+ need help (low priority)

Hi all, When I do Select * from v_$sga; NAME VALUE --- --- Fixed Size ### Variable Size ### Database Buffers### Redo Buffers

RE: SQL+ need help (low priority)

It seems that the column format of col. VALUE is less. Before giving the first command give the following command column value It will display the current column format of column VALUE Now second SELECT doesn't gives any problem 'coz col format is assigned on col. VALUE not on VALUE + 0.

RE: SQL+ need help (low priority)

Hi all, Thank you all, It's work now I must clear it using clear column or exit from sqlplus and run it again Thanks Sinardy -Original Message- Graham Sent: Thursday, 23 August 2001 7:51 PM To: Multiple recipients of list ORACLE-L Sinardy, assuming that this has been done in