Create view

From: K.Y. Fung <kyfung_at_hotmail.com>
Date: 1 Oct 2002 07:24:15 -0700
Message-ID: <c22bb40d.0210010624.16284872@posting.google.com>

How to create a view which have different data type and column length from the original base table?

For example, the base table consists of:

name character 50
telephone character 50
address character 150

the view should have columns:

username    character          30
userphone   character          20

useraddr character varying 100

Regards,
K.Y. Fung Received on Tue Oct 01 2002 - 09:24:15 CDT