Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between CHAR and VARCHAR2? If
VARCHAR2 serves the uses of CHAR why CHAR is still used and
not been discarded yet?

Answer Posted / laxmi narayana moru

VARCHAR2() IS USED TO STORE ALPHANUMERICAL DATA WHERE AS
CHAR() IS USED TO STORE THE CHARACTERS ONLY AND WHICH IS
FIXED LENGTH DATATYPE ...
CHAR() IS PROVIDING FAST ACCESSING COMPARE WITH THE VARCHAR2
()(50%).

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is bdb (berkeleydb)? : Sql dba

1035


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1072


What is a natural join?

1074


Where not exists in sql?

980


How to get list of all tables from a database?

1160


What is having clause in sql?

966


What are dml commands?

1020


How is indexing done in search engines?

982


What is t sql used for?

1015


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1111


What is the difference between inner join and left join?

989


what is the stuff function and how does it differ from the replace function? : Sql dba

1058


What is package in pl sql with an examples?

1036


How do I filter in sql profiler?

995


Can we use distinct and group by together?

1057