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 / hannan

in char it allocates the memory space as static where as in
varchar2 it allocates the memory space as dynamic


OR

char is a space mapping function where as in varchar2 it is
not mapping the space it occupies the exact size of the
string

Is This Answer Correct ?    22 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is relationship? How many types of relationship are there?

1151


Is truncate ddl or dml?

976


What is a join?

1047


What is the basic form of sql query?

924


what is a composite primary key ? : Sql dba

1026


What are different joins used in sql?

1044


Is sqlexception checked or unchecked?

950


How to get each name only once from an employee table?

1097


How to assign sql query results to pl sql variables?

1050


explain advantages of myisam over innodb? : Sql dba

1054


Can we create foreign key without primary key?

966


Why we use joins in sql?

965


What are the different schemas objects that can be created using pl/sql?

1005


Why we use join in sql?

945


How do I run a script in sql developer?

936