Re: Sorting numbers in a text field

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 23 Jan 2007 09:33:34 -0800
Message-ID: <1169573610.125696@bubbleator.drizzle.com>

spudtheimpaler_at_gmail.com wrote:
> DA Morgan wrote:
>

>> spudtheimpaler_at_gmail.com wrote:
>>
>>>> So I don't think this is the correct answer. The correct answer is to
>>>> the run a CREATE DATABASE script, start all over again, and learn to do
>>>> things *properly*.
>>>>
>>>> --
>>>> Sybrand Bakker
>>>> Senior Oracle DBA
>>> Thanks, and I have to agree if it were my database it would have been
>>> different. I didn't mention (because at the time it didn't seem
>>> relevant) that I am in the process of learning SQL, and this was one of
>>> a set of questions set by my trainer.
>> Get a different trainer: Seriously!
>>
>> The only way my students would see this problem would be if the question
>> they were being asked was: "What is wrong with this design."
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

>
> Lol.
>
> Well as I'm sure you can understand, thats not really possible. but
> it's nice to think that when I'm not doing so well it might not just be
> my own fault ;)
>
> It's a Java training course I'm actually on, but apparently SQL is a
> good selling point so you learn some of that too.
>
> Cheers for you input anyway guys!

One of the most fascinating things about our industry is that those that write SQL and PL/SQL ... know they don't know Java.

But those that know Java are convinced they understand databases. Some of the worst schema designs I have ever seen were put together by well meaning, and hopelessly ignorant, Java developers.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jan 23 2007 - 11:33:34 CST