VARCHAR2() IS USED TO STORE ALPHANUMERICAL DATA WHERE AS CHAR() IS USED T

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 / laxmi narayana moru

9 Answers
18318 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / laxmi narayana moru

VARCHAR2() IS USED TO STORE ALPHANUMERICAL DATA WHERE AS
CHAR() IS USED TO STORE THE CHARACTERS ONLY AND WHICH IS
FIXED LENGTH DATATYPE ...
CHAR() IS PROVIDING FAST ACCESSING COMPARE WITH THE VARCHAR2
()(50%).

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql partition function?

1184

What are aggregate and scalar functions?

1003

What are schema-level triggers?

1083

What is cursor and its types?

1047

What are different categories of sql commands?

1115

what is a stored procedure? : Sql dba

1108

What is an emotional trigger?

985

how to use like conditions? : Sql dba

1087

Is it possible to include an insert statement on the same table to which the trigger is assigned?

1000

What is %rowtype in pl sql?

975

what is a unique key ? : Sql dba

1077

What are reports usually used for?

1008

Which join condition can be specified using on clause?

938

Explain the difference between drop and truncate commands in sql?

1022

what is a join? : Sql dba

1008