create object view error

From: <tedchyn_at_yahoo.com>
Date: Thu, 11 Mar 1999 02:13:03 GMT
Message-ID: <7c78r6$tdn$1@nnrp1.dejanews.com>

Sir:
view. Any insight is greately appreciated (oracle 8.0.5). Please reply to : tedchyn_at_yahoo.com
Type
CITY VARCHAR2(25)
test(address address_ty);

------------------------------- --------  ----

create or replace view test_ov(address) address_ty(street,city,state,zip) from test; address_ty(street,city,state,zip) from test invalid column name point to ZIP field

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 10 1999 - 20:13:03 CST