What is the difference between CHAR and VARCHAR2? If
VARCHAR2 serves the uses of CHAR why CHAR is still used and
not been discarded yet?

Answer Posted / suriya

Another difference is accessing a variable declared as char
is faster than, accessing a varchar2.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the most restrictive isolation level? : Transact sql

764


what are enums used for in mysql? : Sql dba

814


Can you select everything, but 1 or 2 fields, without writer's cramp?

685


What is difference between inner join and self join?

776


Does truncate remove indexes?

716






What is an ndf file?

684


Can a select statement fire a trigger?

883


What are %type and %rowtype for?

808


How is data stored in sql?

722


What is sqlca in powerbuilder?

740


How many scalar data types are supported in pl/sql?

711


What does t sql mean?

702


Can we write ddl statements in functions?

787


what are dynamic queries in t-sql? : Transact sql

737


What is primary key and unique key?

758