well thanx,
i will try to work on it until u send the code :D
but i can't promise.. now am checkin the code sent by PHV and try to apply it on my case..
thanx a lot
Boudi
Hello,
u got me right but except for table DESCR it does not contain the items i want to concatenate.. these items are in another table 'LIBELLE'
i will rewrite the example u gave:
MASTER:
SID ItemName Descriptions
1 item1
2 item2
DESCR:
SID LID
1 1
1 2
1 3...
hello,
i think that u miss-understood me... or i explained bad..
what i need is to add a column to the table master called 'description' and where i want to concatenate the values of the descriptions associated with a every master row... so i think i need a vb script to do it.. knowing that a...
hi,
Well if we know what we are concatenating, that will be ok.
I'll be more specific coz maybe i missed to mention something:
let's say we have 3 tables:'master', 'desc', 'libelle'
where 'master' has the key sid, beside other columns
'libelle' has teh key lid, beside other columns
and 'desc'...
Hello,
I have a table 'MASTER' connected to two other tables 'DESC' and 'INCL' where each element in 'MASTER' can have 0 to n elements in 'DESC' and 'INCL'.
What I need is to create a table (MASTER2) similar to (MASTER) with 2 more columns 'DESCRIPTION' and 'INCLUSION' where the values of...
thanx for ur answer but i don't have a support contract with oracle as am using oracle just for testing some oracle text features... I had a reply on another forum sayin that this contract costs some 2000$ to get the CSI code... I won't pay this just for my tests.. that doesn't mean that i don't...
I need to download the oracle database 10.1.0.3 patchset in order to install the Oracle enterprise manager 10.1.0.3 for windows xp 32bits.. to get it from the metalink site I need a CSI code... what to do???
I have oracle database 10g 10.1.0.2, I downloaded Oracle Enterprise Manager 10.1.0.3 and when trying to install i had that error message that these 2 versions are not compatible!! is there any workaround to fix this knowing that I can't find OEM 10.1.0.2 on the servers of oracle and Oracle...
I have an access database table with 2 fields: first is key, second is text... the text field has values separated by a '/' i.e. for the value 1 of the key field, the value of text field is "A3/B4/C5" what I need is a script to separate the values and put them in another table each in a record...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.