alister Messages: 97 Registered: August 2007 Location: India
Member
Hi to everyone
I have migrated from Oracle 8i (8.1.7) to Oracle 10g, but when I execute a query in 8i without any order by clause, I get a result in ascending order. The same query when executed in 10g gives a result which is not ordered. Can anyone advise me as to how to get an order result in 10g. There are many forms and reports which use lov which are not ordered. Can I set the ordering at the database, so that I do not have to alter all the forms and reports.
I have also migrated my forms from 5 to 6, but the combo box in some forms in 6i do not appear at run time. Please show me how I can solve this problem. I have attached an forms5 .fmb file/
alister Messages: 97 Registered: August 2007 Location: India
Member
But why does the same query give me the result in one order in 8i and another order in 10g. Is there any internal ordering ie the way data is stored in the different databases.
cookiemonster Messages: 7480 Registered: September 2008 Location: Rainy Manchester
Senior Member
You got lucky.
Most likely due to the 8i using the RBO which decided to retrieve the data for that query via an index so got it in the order of that index.
In 10g the CBO decided to get the data a different way.
Bear in mind that even in 8i there are things that could have changed that would have stopped that query returning data in that order. Hence - you got lucky. It's nothing to do with how it's stored.
alister Messages: 97 Registered: August 2007 Location: India
Member
Thank you, I guess I really got lucky. Can someone please tell me why to combo box does not appear at run time in forms 6i. The same was working fine in forms 5.
alister Messages: 97 Registered: August 2007 Location: India
Member
I found the maximum length of the data was 1 char, so I increased it to 9 and the combo box appeared at run time and worked fine. My question is why is the combo box working with a char length of 1 in forms 5 and not so in an higher version ie forms6 for the same data.
] 
Members
Search
Help
Register
Login
Home
