Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Create view

Re: Create view

From: James Hayes <James.Hayes_at_exept.de>
Date: Mon, 07 Oct 2002 07:34:16 +0200
Message-ID: <3DA11CD8.B405F174@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 - 00:34:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US