RE: order by clause in a view

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lyall Barbour
Sent: Tuesday, August 07, 2007 5:18 PM
To: oracle-l_at_freelists.org
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



--
http://www.freelists.org/webpage/oracle-l