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.
Printable View
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.
1 ref to table.fieldName i.e replace 1 with your suitable field name of a table.
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;
Thanks for the assistance.