what is the difference between varchar and varchar(2)?
- 4 Answers
- 8347 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 |
What do you understand by a set of books?
What are do's and dont's of Interface?
what is organization id
What is oracle soa suite and what are its different components?
how can u link a org-id with a responsibility in reports?
How you will Diaplay the Company LOGO In report.Can anyone knows please give solution
Types of cursors?
WHAT IS THE FORWARDREFERENCE IN PL/SQL?
Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?
what is the database size you used?
If there is any issue then whom do you report.(this is imp question for every interview)
what is difference between API and Interface?
Oracle Apps Technical 
