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

Question Posted / chandrasekhar.bs

4 Answers
10285 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

Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .

1 Answers TCS,

Can u define operating units inplace of inventory?

2 Answers

Is it possible calling from one report to another? if possible means tell me ?

3 Answers Intelligroup, Satyam,

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers

Hi All, I have one year experience in Oracle Apps.I want to know that what is value of oracle Apps in market?..I have doubt,here I need to learn Oracle Apps more..because I know the opportunities in market ... otherwise need to learn other technologies ?..... And In Oracle Apps ,which is impotant Functional or technical knowledge ?

2 Answers Wipro,

Stored procedure?

4 Answers

How is choreography different from orchestration?

0 Answers

The report output is 10 pages then how many times between pages report trigger will fire?

1 Answers IBM,

What are the Standard Reports and Forms in HRMS?

0 Answers

Name the different Cursor Attributes.

2 Answers Satyam,

what is meant by Table space?

2 Answers

How to create a link between One dependent value set to another Dependent value set

5 Answers Indorama, ManSoft System, Syntel, TE Data,

For more Oracle Apps Technical Interview Questions Click Here