Re: Two questions about views
From: Jon Eveland <jeveland_at_nhtsa.dot.gov>
Date: 1996/04/26
Message-ID: <31810AE0.2207_at_nhtsa.dot.gov>#1/1
Date: 1996/04/26
Message-ID: <31810AE0.2207_at_nhtsa.dot.gov>#1/1
badri wrote:
>
> Hi:
>
> 1) ORDER BY and views
> I am creating a view and need to have an order by statement.
> If I try it, it does not work. How do I make this to work?
It is not possible to create a view with an order by statement. The view will use the indexes of the base tables upon which it is drawn.
> 2) Formatting Numbers and Views
> One of thefields I am selecting is a number and I want it
> to be nicely formatted with commas. How do I do this?
column numeric format 999,999,999
> thanks a lot,
HTH Jon Eveland Received on Fri Apr 26 1996 - 00:00:00 CEST