RE: order by clause in a view

  • From: "Ken Naim" <kennaim@xxxxxxxxx>
  • To: <lyallbarbour@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 7 Aug 2007 21:30:56 -0400

This is a feature that was added in 8i, not a bug that was fixed. Just add
the order by to the query that selects from the view.

 

Ken

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Lyall Barbour
Sent: Tuesday, August 07, 2007 5:18 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: order by clause in a view

 

Hi,

  Simple question.  I've got a solution.  Hoping you peeps could come up
with a better one.

 

select cust_no, count(cust_no)

from table

where <blah>

group by cust_no

order by count(cust_no)

 

works great.

 

create or replace view <table_v> as

select cust_no, count(cust_no)

from table

where <blah>

group by cust_no

order by count(cust_no)

 

some ora error

 

We are running 8.0.5 and that's why.  8i it's fixed.  I'm prepared to create
a temp table and truncate it after my report goes.  But was hoping you guys
might have another way to do this....

 

Thanks,

Lyall Barbour


-- 

We've Got Your Name at Mail.com
<http://www.mail.com/?utm_source=mail_sent_footer&utm_medium=email&utm_term=
070621&utm_content=textlink&utm_campaign=we_got_your_name> 
Get a FREE E-mail Account Today - Choose From 100+ Domains

Other related posts: