Re: Sorting numbers in a text field

From: <spudtheimpaler_at_gmail.com>
Date: 17 Jan 2007 08:07:35 -0800
Message-ID: <1169050055.189178.17580@v45g2000cwv.googlegroups.com>

[...]
>
>
> A database is not a garbage bin.
> If your data is numeric: use a number
> If your data is string: use a varchar2
> Do NOT concatenate attributes in one column.
> Your application will be a complete mess and it will not perform.
> 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. Based on some of the other questions this section appears to be testing us on our logic skills, not just sql abilities.

Thank you for the comments though, they haven't gone un-noted. Received on Wed Jan 17 2007 - 10:07:35 CST