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...


hai,

when to use char and varchar2....?


















































Answer Posted / kranthi

char and varchar2 both we will use for character purpouse
only.but char take how many bytes we r specified in data
type size it will take that much of size.
eg: x char(10);
x:='nani' the remaining 6 character space will b wasted.
but in varchar2 we can use that 6 bytes for another
character also.
i hope so u under stood very well.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is connection pool in oracle?

988


Explain a private synonyms?

1034


How can we find out the current date and time in oracle?

1088


Why does for update in oracle 8 cause an ora-01002 error?

1000


What are the benefits of ordbms?

1083


How to use subqueries with the exists operator in oracle?

1024


What are the ways tablespaces can be managed and how do they differ?

2364


Is it possible to insert comments into sql statements return in the data model editor ?

2553


What is the implicit cursor in oracle?

1102


What is bulk load in oracle?

1068


Explain about your project and its relation to the current job position you are applying to?

1004


What language does oracle use?

1096


How are extents allocated to a segment?

1124


What is meant by recursive hints in oracle?

1084


What is oracle used for?

1022