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

What is a unique constraint?

1073

Is coalesce faster than isnull?

966

How to start the command-line sql*plus?

1053

what is union, minus and interact commands? : Sql dba

1185

What is trigger in sql and its types?

1057

Is it possible to sort a column using a column alias?

1047

Which one is better subquery or joins?

1062

Is sql database free?

976

What is data type in database?

993

How do I run a sql query?

1017

Explain the update statement in sql

992

What is set transaction?

1037

How many unique keys can a table have?

1015

What are the events on which a database trigger can be based?

1189

What is the largest value that can be stored in a byte data field?

1012