Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between varchar and varchar(2)?
- 4 Answers
- 10028 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapnil
When you use varchar data type say varchar(20),
it will reserve the space of 20 bytes even length of
passing parameter is less than 20 byte. But in varchar2, it
will release the remaining space after reserving actual
passing parameter length
| Is This Answer Correct ? | 11 Yes | 7 No |
Answer / srinivasa reddy k
Varchar2 is the oracle datatype
Varchar is not the oracle datatype but still oracle
supports it by converting it into varchar2
But it is not a good practice to use Varchar datatype
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / sandeep kumar
VARCHAR2 is as per the ANSI standard while VARCHAR is not.
Hence we should use VARCHAR2.
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / mohan kumar
VARCHAR--FIXED LENGTH OF DATA TYPE,MEMORY ALLOCATION WILL
NOT TAKE PLACE.
VARCHAR2--IN THIS ORACLE DATA TYPE,MEMORY ALLOCATION WILL HAPPEN
| Is This Answer Correct ? | 2 Yes | 5 No |
In sequence i want to 11 and 15th values how we will write?
What is function?
How relation will be made between modules in oracle financial?
What are the files we submit while your program move to testing instance?
Difference between Bind and Lexical parameters?
what is the standard program for blanket po to process data from interface table to bace table
what are the mandatory parameters in suppler Conversion?
Can u define exceptions twice in same block?
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
what are the difference between 11.5.7 and 11.5.9 in oracle apps
You are working with interfaces if client doesnot give any flat then what will u do?
Do you know where we can check the status of po?
Oracle Apps Technical 
