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 syntax to add a record to a table?

571


Do stored procedures prevent sql injection?

542


What is a clob in sql?

559


What are pl sql data types?

545


What's the difference between a primary key and a clustered index?

508






how can we repair a mysql table? : Sql dba

534


Why do we use view in sql?

530


How to fix oracle error ora-00942: table or view does not exist

565


What is the sql*loader? : aql loader

585


Is grant a ddl statement?

449


How does one use sql*loader to load images, sound clips and documents? : aql loader

668


How do I make my sql query run faster?

462


What sql does db2 use?

537


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

591


What is compound trigger?

553