Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between VARCHAR and VARCHAR2?
- 5 Answers
- 23297 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
Write a program to maintain a singly linked list having the following functions: a) Creation of the list b) Displaying the list. c) Swap all nodes at consecutive even odd positions. E.g.: The nodes at position 1 should be swapped with node 2, node 3 with node 4 and so on.
I have a backlog in Computer Graphics and unable to clear that subject since 2007. Im from JNTU hyderabad. I dont have internal marks, so im unable to clear the subject. Is there any legal way to get my degree bcos of which i cant get proper job. Please help me.
if we give you the job AS A PETROLEUM ENGINEER WHAT WILL YOU DO(that is extraordinary) for our company
how to make resume and what should I include in it?
What is the pattern for HAL Online-exam?
verbal quiz and answers
Explain i.d.e. for visual c++?
funtionalities of loadining and linking
what is overflow and what are the conditions for which overflow possible?
while installing jad file to mobile its giving processing attribute MDlet-jar-URL error...how to fix it
how will u send the idoc
Create an midp application which examines that a phone number which has enters is in the given format * Area code should be one of the following:040,041,050,0400,044
Client server applications
What does "stdafx"header file do?
Why there is Powerfactor difference when we compare to our Capacitive Panel and TNEB side?
