what is the difference between varchar and varchar(2)?

Question Posted / chandrasekhar.bs

4 Answers
10100 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the difference between varchar and varchar(2)?..

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

what is the difference between varchar and varchar(2)?..

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

what is the difference between varchar and varchar(2)?..

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

what is the difference between varchar and varchar(2)?..

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

Post New Answer

More Oracle Apps Technical Interview Questions

Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

0 Answers

I want to develop a oracle applications report using report builder 6i. I have two user parameters. How to provide list of values to parameters, which should show me at the time of submitting concurrent program.

1 Answers Genpact, Y3K Imaginations,

how i can create temporary table?

1 Answers Zensar,

What is oracle soa suite and what are its different components?

0 Answers

What do you understand by a set of books?

0 Answers

Can you differentiate between mediator and osb?

0 Answers

What r the validation done in ap inbound ?

2 Answers Questam,

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?