database

[sigs]

I want differnce between varchar() and varchar2() function in database

[Lop]

Answer: Nothing

VARCHAR2 DATATYPE
The VARCHAR2 datatype specifies a variable length character string.
When you create a VARCHAR2 column, you can supply the maximum number
of bytes of data that it can hold. Oracle subsequently stores each
value in the column exactly as you specify it, provided it does not
exceed the column's maximum length. If you try to insert a value
that exceeds this length, Oracle returns an error.

You must specify a maximum length for a VARCHAR2 column. The
maximum length of VARCHAR2 data is 2000 bytes. Oracle compares
VARCHAR2 values using non-padded comparison semantics.

VARCHAR DATATYPE
The VARCHAR datatype is currently synonymous with the VARCHAR2
datatype. Oracle Corporation recommends that you use VARCHAR2
rather than VARCHAR. In a future version of Oracle, VARCHAR might
be a separate datatype used for variable length character strings
compared with different comparison semantics.

[roger]

I think its just difference of names as far as the usage is concerned...ORACLE recommends the usage of varchar2.