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

What is pl sql in oracle?

1044


Can we use two order by clause in query?

967


define sql delete statement ? : Sql dba

1022


Can you inner join the same table?

992


How to set up sql*plus output format in oracle?

1038


Can you do multiple joins in sql?

1053


What happens when a trigger is associated to a view?

915


Is grant a ddl statement?

897


how to write date and time literals? : Sql dba

962


What are pl/sql packages?

1104


What is the difference between inner join and natural join?

1007


How many types of literals are available in pl sql?

1119


How do you delete data from a table?

1040


What is the use of <> sql?

980


Explain foreign key in sql?

1027