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

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2130


What is an index associated with a constraint?

975


How to retrieve data from an cursor to a record?

1019


How to insert a new row into a table in oracle?

1096


How to see the table columns used in an index?

960


How to use subqueries in the from clause in oracle?

1045


How will you write a query to get a 5th rank student from a table student_report?

1814


What is the quickest way to export a table to a flat file?

920


Is oracle a programming language?

940


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2075


How many types of segments in Oracle?

1014


Is it possible to split the print reviewer into more than one region ?

2223


How do I call oracle stored procedures that take no parameters?

1025


What is oracle latest version?

1038


How to display employee records who gets more salary than the average salary in the department?

998