Posted by steve on 06/15/05 07:14

you are only right about the "next step up"...the rest is *awefully*
assumptive.

oracle 9i...varchar2 max size *is* 32767...exactly. you also fail to note in
my example schema of the table that the "values" column would have to be
"ticked" in order to be able to be used since it is a key word. but, perhaps
you were just letting that one slide.

as for "first normal form"...yes, yes, blah, blah, blah...what you fail to
understand is that perhaps this is part of a large flat-file type of data
table over which i have no control *and* that, were you to see this table,
you'd understand that it does, in fact, make sense in this instance for the
distributor of said data to have chosen a non-normal form.

aside from these over-estimations of your own understanding and complete
lack of mental flexibility - not to mention completely lacking *any*
solution - you have also failed to infer that, just perhaps, what i am
trying to do *is* take this non-formalized data and actually formalize it as
it is processed into a system in which i actually *do* have control over
schemas.

but, by all means, continue to flatter yourself with an apparent attempt to
demean the op!

best regards,

me

p.s. foad.

"Andy Hassall" <andy@andyh.co.uk> wrote in message
news:sdrua1d1lkcbv6gfnkfcl2phshtu1lkf44@4ax.com...
| On Tue, 14 Jun 2005 18:49:57 -0500, "steve" <a@b.com> wrote:
|
| >not getting a response from oracle ngs...hope the post here is not
| >objectionable.
|
| Your post appears completely free of PHP content so comp.databases would
| probably have been the next step up, where you would likely receive the
answer
| I'm about to post...
|
| >i've got a table that's basically:
| >
| >create table foo
| >(
| > id number
| > values varchar2(32767)
| >)
|
| Not in Oracle, you haven't. 4000 is the limit for varchar2.
|
| >the values column contains space-seperated data like:
| >
| >A B C D
|
| This is fundamentally wrong, look up "First Normal Form".
|
| >so the table data would look like:
| >
| >id values
| >________________
| >
| >1 A B C D
| >
| >i need a query that would return:
| >
| >id values
| >____________________
| >
| >1 A
| >1 B
| >1 C
| >1 D
| >
| >basically, for each id i need to return a row for each value in the
values
| >column. any help with this would be much appreciated!
|
| Your schema is wrong. Don't put multiple values in a single field.
|
| Replace the schema with the actual four rows that you post as output.
|
| --
| Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
| <http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

[Back to original message]