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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In oracle application how do you debug or trace errors?

639


Can you explain the difference between architecture followed in 10g & 11g?

656


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

1799


What is a value set? List its various types.

650


What is instead of trigger in where we will use?

674






please send me forms, xml pulisher questions,answers

1654


Explain what are the tables of auto invoice?

647


Explain oracle apps architecture.

763


WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

2591


How is choreography different from orchestration?

649


What is count(*) from po_vendors(any table)?

639


In hierarchical structure of a database? we have write query from where we should start?

1702


Do you know what are user profiles in apps. Any examples you can give?

660


do you know is it possible to run the interface without using oracle apps?

646


How can we import the data into a database using sql * loader?

679