Create view
From: K.Y. Fung <kyfung_at_hotmail.com>
Date: 1 Oct 2002 07:24:15 -0700
Message-ID: <c22bb40d.0210010624.16284872_at_posting.google.com>
How to create a view which have different data type and column length from the original base table?
useraddr character varying 100
Date: 1 Oct 2002 07:24:15 -0700
Message-ID: <c22bb40d.0210010624.16284872_at_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
username character 30 userphone character 20
useraddr character varying 100
Regards,
K.Y. Fung
Received on Tue Oct 01 2002 - 16:24:15 CEST