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

Question Posted / chandrasekhar.bs

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

1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function

2 Answers Zensar,

What should be the batch size (number of customer records) general guidelines for optimal performance?

1 Answers

where u do setup of operating unit?

1 Answers TCS,

In which directory your flatfile is given?if u connected different instance where it is find?

3 Answers

what is pick selection list generation report.

3 Answers

How can a process be deployed in soa?

0 Answers

Is that Possible To create package without Specification , If Yes Give any Examples

2 Answers PWC,

how can i print random rows in plsql table

0 Answers Fujitsu, KPIT,

any one can expalin report registration steps?

6 Answers Infosys,

In 11i we didn't have AP_Invoice_Lines Table, but in R12 this table is available, what is reason, advantage?

1 Answers Accenture,

what do you mean by value sets

8 Answers Convergys,

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

1 Answers IBM,

For more Oracle Apps Technical Interview Questions Click Here