Re: displaying 2 columns as 1

There a couple of ways to do this. In SQL you need to do

SELECT firstname || surname AS name
FROM tablename;

<note the AS can be left out>

In plsql you could have:

w_name := firstname || surname;

There is also a function called CONCAT that can be used, but it is as easy to use the above. I also suggest you go to tahiti.oracle.com and do some searching on this topic and others as this is a fairly simple problem (why I could solve it!) and if you are having difficulty with it then you need to look at the documentation first.

Anyway, hth
Robert Received on Thu May 16 2002 - 15:36:17 CEST