By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,025 Members | 2,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,025 IT Pros & Developers. It's quick & easy.

How to single numeric values from a field in a table which has multiple numeric value

P: 6
How to single numeric values from a field in a table which has multiple numeric value in a field of a table.And that table contains thousands of records.

Suppose we have a table customer having fields like
CUST_ID, CASTE, AGE etc.
101 (12,89,76,34,66,90,36) 23
128 (27,45,71,211,43,107,67,451) 26
117 (11,23,32,265,142,88,67,98) 30
.................................................. ..........
.................................................. ..........
Now i want to get single values of caste field for each cust_id, we have thousand of record in table.

Thanks in advance..
Pardeep
Feb 24 '07 #1
Share this Question
Share on Google+
1 Reply


vijaydiwakar
100+
P: 579
How to single numeric values from a field in a table which has multiple numeric value in a field of a table.And that table contains thousands of records.

Suppose we have a table customer having fields like
CUST_ID, CASTE, AGE etc.
101 (12,89,76,34,66,90,36) 23
128 (27,45,71,211,43,107,67,451) 26
117 (11,23,32,265,142,88,67,98) 30
.................................................. ..........
.................................................. ..........
Now i want to get single values of caste field for each cust_id, we have thousand of record in table.

Thanks in advance..
Pardeep
basically this is not a good normalised tbl........
anyway u may try substr fun in qry
Feb 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.