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