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

create table test(aa char):=by using char create the table with out spicifing the lengh(by default it will create lenth 1)default size is 1 byte

by using varchar2 with out spicifing the lengh we cont able to create the table.There is no default size

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key an index?

944


How do I run pl sql in sql developer?

1058


How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383


What are the usages of sql?

1010


Why is theta join required?

1079


How do you optimize a stored procedure in sql?

892


what are the advantages of sql ? : Sql dba

999


How to Execute a Package in PL/SQL.?

1108


Which is faster union or join?

901


In a distributed database system, can we execute two queries simultaneously?

991


What are some emotional triggers?

927


what is the difference difference between procedure and packages

10250


Can you do multiple joins in sql?

969


What is trigger and types?

964


How do I tune a sql query?

933