How do I create this view

Group :

I have a table

Table ADDR_TYP as

id varchar(10),
usrid varchar2(10),
state varchar2(40),
addr varchar2(40),
zipcode varchar2(40);

And I need to create a view

ADDR_TYP_VW as

id,
usrid,
log_id(has values 1 for state,2 for addr and 3 for zipcode);

Table ADDR_TYP

id	usrid	state	addr	zipcode
01	78	OH	xyz	12345


View ADDR_TYP_VW
id	usrid	log_id
01	78	1   -- corresponds to state
01	78	2   -- corresponds to addr
01	78	3   -- corresponds to zipcode

Any help is appreciated.

Thanks in advance

rama
kramakri_at_csc.dayton.com Received on Sat Nov 09 1996 - 00:00:00 CET