Home » RDBMS Server » Server Administration » 3 fields into 1 virtual
3 fields into 1 virtual [message #375145] Tue, 31 July 2001 04:11
Konstantin
Messages: 6
Registered: June 2001
Junior Member
Hi.

I have a table const_db. There are 3 fields similar by type of data it contains: pc_nameofplace_1,pc_nameofplace_2,pc_nameofplace_3.
I need a query that will return in one virtual column all the data these fields contain. The data which is included in pc_nameofplace_1 can repeat in pc_nameofplace_2 or pc_nameofplace_3. I need no duplicates.

Thanks in advance,
Konstantin

Report message to a moderator

Previous Topic: Re: Get back SQL used to create a view?
Next Topic: Is archive log mode available with oracle 8i standard edition
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 06:24:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.