CREATE VIEW with * and other stuff?
From: Jon Derman <derman_at_mindspring.com>
Date: 1998/03/09
Message-ID: <3503425a.39212654_at_news.mindspring.com>#1/1
Date: 1998/03/09
Message-ID: <3503425a.39212654_at_news.mindspring.com>#1/1
Given that one can create a view of a table with something like this:
CREATE VIEW TEST_VIEW AS
SELECT * FROM TEST;
...is there a simple way to create a view that contains everything in
a given table -- plus a couple of other things (calculated things, for
example) -- without having to list everything out? Something like
this:
CREATE VIEW TEST_VIEW AS
SELECT *, A+B, SUBSTR(C,1,1) FROM TEST;
Received on Mon Mar 09 1998 - 00:00:00 CET