SQL concatenation issue for Oracle 9i

[bingbing]

Hi,

I'm currently using Oracle 9i for a class database project. I'm kinda stuck at the following problem...I have a view called LING shown below:

A B C D
- - - -
2 4 1 1

The problem is I'm trying to create a view (Oracle's view) called TEMP that will look like this:

A B C D E
- - - - ------
2 4 1 1 2411

I've tried using CONCAT (concatenation) but to no avail. The following is a sample of my code:

create or replace view TEMP AS
select LING.A, LING.B, LING.C, LING.D, LINK.E
from LING, LINK
where E=
(select A||B||C||D from LING);

The view TEMP can be created but there's nothing inside when i check using select.


Anyone knows the correct syntax to combine string and put in column E? Thanks for your time...

 

[cianw]

create or replace view TEMP AS
select LING.A, LING.B, LING.C, LING.D, A||B||C||D as E
from LING

 

[bingbing]

Thanks for you help..