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
Can sql function call stored procedure?
What does <> sql mean?
what are the 'mysql' command line arguments? : Sql dba
Do foreign keys improve performance?
How do I add a primary key to a table?
Can we use ddl statements in stored procedure sql server?
What is restrict in sql?
What is cross join example?
How are sql commands classified?
What is the difference between sql and mysql?
Can we use delete in merge statement?
What are the types of sql commands?
How many types of functions are there in sql?
Does oracle use sql?
Can 2 queries be executed simultaneously in a distributed database system?