Re: to_Char or not to_Char

Will,

Ha, now I see why Sybrand Bakker said "this is a lousy datamodel". My question may not have been clear. What I wanted to do is, for "string" type of data type (char,varchar2,nchar,nvarchar2), use To_char function, so,
for n* string data type, the SQL statement does not have to use N' prefix.
This comes handy, when the program does not have knoledge beforehand of the database schema (structure). Of course, the overhead is to determine data type first.

And certainly, I agree with you on
"you should *only* have numbers in
number columns or strings in string columns or dates in date columns, etc.".

Thanks.

Don

wkooiman_at_oracledba.com (Will Kooiman) wrote in message news:<8693f67d.0206132041.32a3cea6_at_posting.google.com>...
> It has everything to do with the data model. With very few exceptions
> (I've done this once in 14 years), you should *only* have numbers in
> number columns or strings in string columns or dates in date columns,
> etc.
>
> I started to offer a suggestion on how to make this work, but there
> are no good solutions. The best solution is probably to fix your data
> model.
Received on Fri Jun 14 2002 - 18:52:48 CEST