Re: Help on Oracle8i SQL Syntax to create VIEW
Date: Mon, 16 Apr 2001 19:13:50 +0800
Message-ID: <3adad4ac.0_at_news2.tm.net.my>
hi,
as far as i know the concatenation character in oracle is || so if u want to concatenate use
select name, address || ' ' || city || ' ' || state from company;
hope this helps
regards,
aparna
"Unknown User" <unknown_at_unknown.com> wrote in message
news:e56ddt43jrvhe72vh2hakcj86gk0e593do_at_4ax.com...
> Hi,
>
> I am trying to create a view by combining the address fields into one long
address on Oracle 8i.
> What is the correct syntax? Thanks.
>
> SQL> CREATE VIEW ENVELOPE (COMPANY, MAILING_ADDRESS) AS
> 2 SELECT NAME, ADDRESS + " " + CITY + ", " + STATE
> 3 FROM COMPANY;
> SELECT NAME, ADDRESS + " " + CITY + ", " + STATE
> *
> ERROR at line 2:
> ORA-00904: invalid column name
Received on Mon Apr 16 2001 - 13:13:50 CEST