Select Distinct 1 state

[CBW]

Can anyone tell me what the 1's in here refer to?

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


Thanks for any assistance.

[pks]

1 ref to table.fieldName i.e replace 1 with your suitable field name of a table.

[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;

[CBW]

Thanks for the assistance.