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

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 to_char(b.dateorder,'mm')

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 SQL*Pl

Re: SQL+ need help (low priority)

Sinardy, assuming that this has been done in SQL*Plus, it looks like you have a column called value defined as being character. If you type column value you will probably get output something like... COLUMN value ON FORMAT a20 to change this you would either have to say col value form

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. Ju