What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?

Answer Posted / thilaga

char 2000 byres, varchar 4000 bytes

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the most important ddl statements in sql?

750


What is synchronized subquery?

824


what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

703


What if we write return in procedure?

974


What are the usages of sql?

752






Which is better trigger or stored procedure?

689


What are aggregate functions in sql?

841


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

756


What are the two types of periodical indexes?

662


How to Execute a Package in PL/SQL.?

807


Does inner join remove duplicates?

699


What are the three pl sql block types?

724


What are inbuilt functions in sql?

794


What is sql select statement?

703


Does view contain data?

788