Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between VARCHAR and VARCHAR2?
- 5 Answers
- 23531 Views
- I also Faced
- E-Mail Answers
Answer Posted / shishal
VARCHAR2 is Oracle and VARCHAR is ansi standard. Regardless
how they behave or how big it can be it's simply a vendor vs
standard issue.
There is a quotation from Christopher Allen “Oracle Database
10g, PL/SQL 101”:
“There is a datatype named VARCHAR as well. In early
versions of Oracle the maximum length of a VARCAR column was
1,000 characters, later expanded to 4,000 characters for the
datatype VARCHAR2. In current version of Oracle, both
datatypes enjoy 4,000-character limit. However Oracle
Corporation says they may change the behavior of a VARCHAR
column in future – and we have no way of knowing how the
“changed” VARCHAR will behave – so…”
Varchar2 is variable width character data type, so if you
define column with width 20 and insert only one character to
tis column only, one character will be stored in database.
Char is not variable width so when you define column with
width 20 and insert one character to this column it will be
right padded with 19 spaces to desired length, so you will
store 20 characters in the dattabase .Varchar data type from
Oracle 9i is automaticlly promoted to varchar2 .
| Is This Answer Correct ? | 27 Yes | 12 No |
Post New Answer View All Answers
what is the differences between software engineering and other engineering disciplines.
What is Campus selection process of patni at Adcet,Ashta at 24th dec 2010.Also give apti syllabus.
is built-in data-type are abstract data-types in java
What is the instruction to load the register B?
what is the class of generator A b & c
A code which had some declarations of some data items. There were a couple of normal data items(char,int..) and some pointers as well and a malloc call. You have to find the total memory taken up in the stack(Hint:Pointers and all are allocated in heap, not in stack, so dont count them).Also in most of these questions, they were specifying that the OS was 32 bit
WHAT IS DIFFERENT BETWEEN YOU AND OTHER APPLICANT TO GIVE YOU THE JOB
model question papers of GrayOrange company
i want questions only on code part like general logics in c and java
A rectangular beam section of 300 mm width and 500 mm effective depth is reinforced with 4 bars of 20 mm diameter, what shear reinforcement is required to resist 200 kN shear (use working stress method)?
What are the frequently asked technical engineer ques?
what are register variables?what are the advantages of using register variables in c language?
how to store the vacuum in tank? its possible? what are the units for measure the vacuum ?
What would be your first invention?
the conditional jump instruction in 8086 have a displacement of more than 1 byte.explain how would you tackle a situation in which it is required to branch,on some condition,to a location which is more than 120 bytes away.
