Help on Oracle8i SQL Syntax to create VIEW

From: Unknown User <unknown_at_unknown.com>
Date: Thu, 12 Apr 2001 23:17:06 -0700
Message-ID: <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 Fri Apr 13 2001 - 08:17:06 CEST

This message: [ Message body ]
Next message: Eric Fortin: "Re: Help on Oracle8i SQL Syntax to create VIEW"
Previous message: Rupert Prebble: "Re: How do I install 8i onto windows ME?"
Next in thread: Eric Fortin: "Re: Help on Oracle8i SQL Syntax to create VIEW"
Reply: Eric Fortin: "Re: Help on Oracle8i SQL Syntax to create VIEW"
Reply: Aparna: "Re: Help on Oracle8i SQL Syntax to create VIEW"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message