Another difference is accessing a variable declared as char is faster tha

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?

Question Posted / suriya

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

Please Help Members By Posting Answers For Below Questions

How to avoid duplicate records in a query?

987

How do you use a while loop in pl sql?

993

How do I run sql profiler?

1051

what are the performance and scalability characteristics of mysql? : Sql dba

985

How to write html code in pl sql?

1097

Which is faster count (*) or count 1?

1009

Why commit is not used in triggers?

1023

Can we use pl sql in mysql?

994

What is the requirement of self-join?

1098

Is delete faster than truncate?

993

Are sql database names case sensitive?

980

What is a function in oracle pl sql?

1014

Is pl sql different from sql?

967

How do I remove sql plus from windows 10?

1075

what is row? : Sql dba

1205