CREATE VIEW with * and other stuff?

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 CST