Free Jobs
Reference




Java Forums: Core Java (15) J2EE (3) EJB (5) Servlet (3) JDBC (6) Hibernate (2) Struts (1) Swing (1) Oracle (7) JSP (4) Other (10)

Topic: How to differentiate among CHAR VARCHAR and VARCHAR2 data types in oracle

To get the Posted Questions details daily in your mail Click Here

Share this Post on Facebook/Twitter/Orkut Bookmark and Share





User: pankaj244 Post Date: 02 Nov 2010 09:04

Introduction:
The keywords CHAR ,VARCHAR, and VARCHAR2 appear similar
however there is lot of difference among them.
we will understand the difference among these three in this article.



Main Content:

CHAR :
These types are used to store character string values
CHAR should be used for storing fix length character strings
If this type is used to store varibale length strings, it will waste a lot of disk space.

VARCHAR2:
These types are used to store character string values
VARCHAR2 should be used to store variable length character strings

VARCHAR:
These types behaves same like VARCHAR2.
However, this type should not be used as it is reserved for future usage.







Conclusion:
Thus we found that generally we will be dealing with VARCHAR2 in case
of variable length string storage.



About Writer:
Hi , I am Oracle Developer From Bangalore


Writer's Link:

Writer's Email:







Comments:
Post Comment





Similar Articles Top ArticlesLatest Articles Other Articles by this Author







www.freejobsreference.com Copyright © 2009-2011 | All Rights Reserved
All content of this website is protected by copyright laws and should not be reproduced in any form or by any means without written permission
(Best viewed in IE 8.0+ or Firefox 3.0+ at resolution of 1024 * 768 or higher)