QTY_SOLD displaying as #########
I am trying to enter these commands into my database, the purpose of this is so that i can get practice using the Where clause to prompt for specific data. However when i enter the code below my select statement gets truncated and my QTY_SOLD displays as ######### 


Here is my code-
Select Distinct product.prod#, mfr, Prod_desc, Model
--	cust_fname, cust_lname 
from	product join sale_product 
	on product.prod# =Sale_product.prod#
	Join Sale
	on Sale.inv# =Sale_product.inv#
	join customer
	on customer.cust# =sale.cust#
where	product.prod# = &&product_number 
--Order by Cust_lname, Cust_fname, sale_date
;
--Detail section, all you have to do is comment out the product information 
Select  
	cust_fname, cust_lname,Cust_phone,sale_date, qty_sold
from	product join sale_product 
	on product.prod# =Sale_product.prod#
	Join Sale
	on Sale.inv# =Sale_product.inv#
	join customer
	on customer.cust# =sale.cust#
where	product.prod# = &&product_number 
Order by Cust_lname, Cust_fname, sale_date;
--Summary section 
Select count (sale.inv#)"#sold",sum (qty_sold)
--	product.prod#, mfr, Prod_desc, Model
--	cust_fname, cust_lname, ...
from	
	product join sale_product 
	on product.prod# =Sale_product.prod#
	Join Sale
	on Sale.inv# =Sale_product.inv#
	join customer
	on customer.cust# =sale.cust#
where	product.prod# = &&product_number 
--Order by Cust_lname, Cust_fname, sale_date;




Here is the output i get.


               PROD# MFR             PROD_DESC            MODEL
-------------------- --------------- -------------------- ------------------
                 202 EVGA            MOTHERBOARD          MOTHERBOARD 999XR

old   9: where  product.prod# = &&product_number
new   9: where  product.prod# = 202

CUST_FNAME     CUST_LNAME     CUST_PHONE    SALE_DATE   QTY_SOLD
-------------- -------------- ------------- --------- ----------
MARY           LIU            (530)345-5678 21-APR-12 ##########
MARY           LIU            (530)345-5678 25-APR-12 ##########
MARY           LIU            (530)345-5678 01-MAY-12 ##########
HASAN          MACNEIL        (530)358-9874 26-APR-12 ##########
MICHAEL        PEARLMAN       (530)342-1114 22-APR-12 ##########
MICHAEL        PEARLMAN       (530)342-1114 23-APR-12 ##########

6 rows selected.

old  11: where  product.prod# = &&product_number
new  11: where  product.prod# = 202
truncating (as requested) before column SUM(QTY_SOLD)--PRODUCT.PROD#,MFR,PROD_DESC,MODEL--CUST_FNAME


               #sold
--------------------
                   6


Any help would be appreciated.
QTY_SOLD displaying as #########
===

I am trying to enter these commands into my database, the purpose of this is so that i can get practice using the Where clause to prompt for specific data. However when i enter the code below my select statement gets truncated and my QTY_SOLD displays as ######### 


Here is my code-
Select Distinct product.prod#, mfr, Prod_desc, Model
--	cust_fname, cust_lname 
from	product join sale_product 
	on product.prod# =Sale_product.prod#
	Join Sale
	on Sale.inv# =Sale_product.inv#
	join customer
	on customer.cust# =sale.cust#
where	product.prod# = &&product_number 
--Order by Cust_lname, Cust_fname, sale_date
;
--Detail section, all you have to do is comment out the product information 
Select  
	cust_fname, cust_lname,Cust_phone,sale_date, qty_sold
from	product join sale_product 
	on product.prod# =Sale_product.prod#
	Join Sale
	on Sale.inv# =Sale_product.inv#
	join customer
	on customer.cust# =sale.cust#
where	product.prod# = &&product_number 
Order by Cust_lname, Cust_fname, sale_date;
--Summary section 
Select count (sale.inv#)"#sold",sum (qty_sold)
--	product.prod#, mfr, Prod_desc, Model
--	cust_fname, cust_lname, ...
from	
	product join sale_product 
	on product.prod# =Sale_product.prod#
	Join Sale
	on Sale.inv# =Sale_product.inv#
	join customer
	on customer.cust# =sale.cust#
where	product.prod# = &&product_number 
--Order by Cust_lname, Cust_fname, sale_date;




Here is the output i get.


               PROD# MFR             PROD_DESC            MODEL
-------------------- --------------- -------------------- ------------------
                 202 EVGA            MOTHERBOARD          MOTHERBOARD 999XR

old   9: where  product.prod# = &&product_number
new   9: where  product.prod# = 202

CUST_FNAME     CUST_LNAME     CUST_PHONE    SALE_DATE   QTY_SOLD
-------------- -------------- ------------- --------- ----------
MARY           LIU            (530)345-5678 21-APR-12 ##########
MARY           LIU            (530)345-5678 25-APR-12 ##########
MARY           LIU            (530)345-5678 01-MAY-12 ##########
HASAN          MACNEIL        (530)358-9874 26-APR-12 ##########
MICHAEL        PEARLMAN       (530)342-1114 22-APR-12 ##########
MICHAEL        PEARLMAN       (530)342-1114 23-APR-12 ##########

6 rows selected.

old  11: where  product.prod# = &&product_number
new  11: where  product.prod# = 202
truncating (as requested) before column SUM(QTY_SOLD)--PRODUCT.PROD#,MFR,PROD_DESC,MODEL--CUST_FNAME


               #sold
--------------------
                   6


Any help would be appreciated.