I am pretty sure that asc and desc are evaluted equally and should be evaluated as they appear in the order by clause. If you run this query in SQL Plus you should see the results as you wanted them. I believe that the issue lies with the grouping. Man, thats a really good quetion though. I have...
I would check to ensure that you have the most up-to-date version of the Oracle client on all machines. I had a similar issue in the past and that was the cause. Oracle is nothing if not buggy.
I would say that if you are going to do a pay site, then for $20/month or less you can have access to Perl. I pay less than 20 for my site complete with Perl, and thats in Canada. I know for database hosting it can start at around the $50/month mark. What I did temporarily is host my ste for $20...
You can in fact use Perl to access an MS Access dataase but I believe that these other learned Perl gurus are right. If you are using a free hosting site then there isn't any way they are going to allow you to host a database of any kind on their servers. (Besides Access is horrible. mySQL would...
First...thanks for the response. I appreciae t and if you ever need a hand with Oracle you can buzz me anytime. The issue is that I have used your example, which works like a charm, however in this situation I cannot get all the values loaded into my array. What happens is this... The ascii file...
Please forgive me for this qestion. I am a newbie and I wrote a script that is supposed to take an exported ascii file that contains a delimited list of id numbers, then cut out all the delimiters (these can include ,.;:|, newlines and tabs) and then it takes a substr of the id number (so if the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.