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 do you mean by stored procedures? How do we use it?

513


What is the non-clustered index in sql?

582


Can we use delete in merge statement?

507


What are sql indexes?

534


Explain the structure of pl/sql in brief.

613






How many times can we commit in a loop?

560


What are the steps for performance tuning.

831


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

546


What are all the ddl commands?

616


what are the differences between require and include, include_once and require_once? : Sql dba

518


what is the command used to fetch first 5 characters of the string? : Sql dba

1126


Is pl sql useful?

535


Explain constraints in sql?

563


Which sql most popular?

541


Explain exception handling in pl/sql?

522