-
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.
Pras :cool:
-
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;
Vijay.s
-
Thanks for the explanation
Thanks for the assistance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|