Re: Create view
From: James Hayes <James.Hayes_at_exept.de>
Date: Mon, 07 Oct 2002 07:34:16 +0200
Message-ID: <3DA11CD8.B405F174_at_exept.de>
Date: Mon, 07 Oct 2002 07:34:16 +0200
Message-ID: <3DA11CD8.B405F174_at_exept.de>
> I guess this question try to test us, once again, what we have NOT
> learn. To define a view that have column of different type and size
> than the base table with just one SQL statement.
If you are doing m358 there are examples in block 3 towards the end, with plans of how to do most of what you ask!
Cheers and good luck in the exam!
Hajaansh
> The first response to my original question works. What we have not
> learn is the use of CAST in the way presented by Tibor Karaszi.
>
> Thanks and regards,
> K.Y. Fung
Received on Mon Oct 07 2002 - 07:34:16 CEST