Re: Sorting numbers in a text field

On Jan 23, 5:33 pm, DA Morgan <damor..._at_psoug.org> wrote:
> spudtheimpa..._at_gmail.com wrote:
> > DA Morgan wrote:
>
> >> spudtheimpa..._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
> >> damor..._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
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Thats interesting. I've not been in the field long enough to know, and with utmost respect I have yet to find a language is like/am capable of as little as PL/SQL. Maybe I don't like because I don't get, or vice versa, but either way I can never see myself being a DBA. We don't get along.

Still, Java developers thinking they know SQL, something I will look out for in my travels.

Thanks again!

Micth. Received on Mon Jan 29 2007 - 09:19:54 CST