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
Is join and inner join the same?
what is row? : Sql dba
What do you mean by query optimization?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Does sql use python?
what are the limitations of identity column? : Transact sql
What is nvarchar in sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
what is a composite key ? : Sql dba
what is innodb? : Sql dba
What are the ways on commenting in a pl/sql code?
What is substitution variable in pl sql?
What is a left join?
What is informix sql?
Write an sql query to select all records from the table?