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
What is a trigger word?
How do you write a subquery?
what is heap table? : Sql dba
What does sign mean sql?
Explain aggregate functions are available there in sql?
how many tables will create when we create table, what are they? : Sql dba
how to rename an existing table in mysql? : Sql dba
Can we rollback after truncate?
How long does it take to learn pl sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
what is denormalization. : Sql dba
What is equi join in sql?
Can we create index on primary key?
What is an implicit commit?
What is oracle pl sql developer?