Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    107

    Unanswered: Diff b/w varchar & varchar2???

    hi friends,

    can anyone tell me what is the difference between varchar & varchar2 in oracle.

    Jake
    PS: Saravanan.R, i searched the forum before posting this ;-)

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    191

    No need to search web

    Hi,

    There is no difference between varchar2 and varchar.
    Oracle introduce varchar2 in new release.

    You don' have to searh web before posting your question!!!
    Even if the question are repeating there is no harm.
    Things will get refresh...Searching solution in web is not interactive. Even if u get solution in the web but if you don't know how it has done, then it has no meaning!!!
    Thats why forum are for!!!!

    Thanks,
    Pagnint
    (No need to search web before posting new question)

  3. #3
    Join Date
    Oct 2003
    Location
    India
    Posts
    55

    Difference in Varchar & Varchar2

    Hi,

    What i beleive is that Varchar can grow in size but it wont reduce if the data is less but Varchar2 will reduce the space consumed if the data is less than the set length.

    Regs
    Sree

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    191
    Hi sreeraj,

    I dont think there is any difference.

    Thanks,
    Pagnint
    (No need to search web before posting new question)

  5. #5
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    I always find reading Oracle's documentation comes in handy! This is what it says about VARCHAR:

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

    That was from the 9i SQL Reference. The 10G SQL Reference says the same.

  6. #6
    Join Date
    Feb 2004
    Posts
    107
    Hi friends,
    Thanks a lot for the clarification.

    Parag: I understood your point... i also agree that everyone should post there queries here rather than searching the net, for the matter of fact that one could save lot of time by posting here... additionally, one could interactively discuss with other people and come to a better understanding & solution to the problem...

    Jake

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •