Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

OE


Description  Columns  Query  Constraints  Referenced by  Triggers  

PRODUCT_PRICES

Columns

Column Datatype Nullable Insertable Updateable Deletable Comment
CATEGORY_ID NUMBER(2,0) Y NO NO NO  
#_OF_PRODUCTS NUMBER(,) Y NO NO NO  
LOW_PRICE NUMBER(,) Y NO NO NO  
HIGH_PRICE NUMBER(,) Y NO NO NO  

Query

SELECT category_id
,      COUNT(*)        as "#_OF_PRODUCTS"
,      MIN(list_price) as low_price
,      MAX(list_price) as high_price
FROM   product_information
GROUP BY category_id

Generated by
OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005