Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between varchar and varchar(2)?
- 4 Answers
- 10020 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 is multi org?
Except the SRS window in which we can submit the concurrent program.
How do u customize the Reports?
P_CONC_REQUEST_ID mandatory in oracle reports to run in oracle applications or not ( I am not talking about running in report builder or D2k ) or not ?
9 Answers CSC, IBM, KPIT, Oracle,
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
Can function be overload?
sourcing in GL
What is workflow?Explain with a example?
in oracle workflow if i want to send a mail to the user after sending if the user didn't approve the mail after 10 mins it is automatimatically approved how we can approach?
How we print the multi language in report?can any one give me step bye step explanation.
2 Answers HCL, IBM, Tech Mahindra,
What do you understand by soa and what are the benefits of using this architecture?
What is Value Set?
Oracle Apps Technical 
