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
Does a join table need a primary key?
what are the different tables present in mysql? : Sql dba
What are pl sql data types?
How do you declare a constant?
What is sql indexing?
Which join condition can be specified using on clause?
What is the purpose of the partition table?
how would you enter characters as hex numbers? : Sql dba
Explain what is an index?
Can we delete column in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is primary key in db?
What is cartesian join in sql?
what is clause? : Sql dba
What are the basic techniques of indexing?