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

how to increment dates by 1 in mysql? : Sql dba

1030


What is the benefit of foreign key?

1068


Can we call a function containing dml statements in a select query?

1024


What are functions in sql?

995


What are the most important ddl statements in sql?

1186


Is pl sql and postgresql same?

1180


How exception is different from error?

1065


what is a record in a database ? : Sql dba

1104


Is record in oracle pl sql?

1015


How do I remove sql plus from windows 10?

1145


Does truncate table reset auto increment?

1049


Why do we need unique key in a table?

1003


What is the difference between partition and index?

1056


What are the types of views in sql?

1140


how to get help information from the server? : Sql dba

989