Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update/Select on CHAR Column Behaves Differently In Stored Procedure
Agreed. I may go with the index, but I like your suggestion as well.
Ideally, I can work towards changing that column to VARCHAR2 down the
road (have to modify and fully test other app). The CHAR(11) is just a
waste of space (the values will never exceed 8 characters).
Thanks.
Jesse Received on Thu May 05 2005 - 14:47:22 CDT