What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?

Answer Posted / pavan_1981

VARCHAR2(size):variable lenght character data maximum size
is 4000 and minimum is 1
char2(size):fixed lenght character data of lenght size bytes
minimum and default is 1 and maximum is 2000.

Is This Answer Correct ?    31 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to include character strings in sql statements? : Sql dba

737


What is interval partition?

724


Is ms sql is free?

712


What is an exception in PL/SQL? What are the two types of exceptions?

851


what is a scheduled jobs or what is a scheduled tasks? : Sql dba

735






how to include comments in sql statements? : Sql dba

723


Does sqlite need a server?

741


What does rownum mean in sql?

722


What is denormalization in a database?

792


Whis is not false in primary key?

1169


how to start mysql server? : Sql dba

864


Are subqueries better than joins?

718


What is synchronized subquery?

824


Explain what is a column in a table?

764


What are views in sql?

721