Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Magic of varchar2

Re: Magic of varchar2

From: Anurag Varma <avoracle_at_gmail.com>
Date: 14 Mar 2006 16:42:26 -0800
Message-ID: <1142374915.529547.129970@j52g2000cwj.googlegroups.com> 






Lets say there is no impact on storage/performance.



So do you think it would be wise for a data model to
define ALL varchar2 columns as varchar2(4000)?



What about it denoting the max column length? Why would
you want to define a column as varchar2(500) when it will
only store 10 bytes?



Anurag
Received on Tue Mar 14 2006 - 18:42:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US