Select Distinct 1 state

[vbaskar]

IN THIS CURSOR...

STATE AND DEPTH COLUMN WILL HAVE VALUE 1 AND ICON FIELD WILL HAVE NULL VALUES ETC..

state, depth is an alais column name for 1
labels is an alias column name for category
icon is an alias column name for NULL
data is an alias column for category.

CURSOR c_category is select distinct 1 state, 1 depth, category labels, null icon, category data
from products
order by category;