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
How do you identify a primary key?
What is the function that is used to transfer a pl/sql table log to a database table?
What are the types of triggers in sql?
Which join is like an inner join?
What is java sql drivermanager?
Does truncate require commit?
what is the difference difference between procedure and packages
Why join is faster than subquery?
Is sql pronounced sequel or sql?
When is a declare statement required?
How do you run a query?
Is sql procedural language?
What are the different types of database management systems?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is pl/sql language case sensitive?