Answer / shishal

VARCHAR2 is Oracle and VARCHAR is ansi standard. Regardless
how they behave or how big it can be it's simply a vendor vs
standard issue.
There is a quotation from Christopher Allen “Oracle Database
10g, PL/SQL 101”:

“There is a datatype named VARCHAR as well. In early
versions of Oracle the maximum length of a VARCAR column was
1,000 characters, later expanded to 4,000 characters for the
datatype VARCHAR2. In current version of Oracle, both
datatypes enjoy 4,000-character limit. However Oracle
Corporation says they may change the behavior of a VARCHAR
column in future – and we have no way of knowing how the
“changed” VARCHAR will behave – so…”


Varchar2 is variable width character data type, so if you
define column with width 20 and insert only one character to
tis column only, one character will be stored in database.
Char is not variable width so when you define column with
width 20 and insert one character to this column it will be
right padded with 19 spaces to desired length, so you will
store 20 characters in the dattabase .Varchar data type from
Oracle 9i is automaticlly promoted to varchar2 .

Answer / m arunachalam

These is a simple difference only...

Varchar- It can fixed size to the memory.
Ex:varchar(50)->Memory can take 50 characters to
allocate...
If You given string 'arunachalam' it contains 11 characters
and assign to memory. Remaining 39 character also assign to
empty character in memory....

Varchar2-It can fixed size by your given data length..
Ex:Varchar2(50)->Memory can take 50 characters to allocate...
If You given string 'arunachalam' it contains 11 characters
and assign to memory. Remaining 39 character here not assign
to memory and memory size should be reduced from remaining
size....

Answer / vetrivel

VARCHAR:
Stores strings of variable length.
The length parameter specifies the maximum length of the strings
It stores up to 2000 bytes of characters
It will occupy space for NULL values
The total length for strings is defined when database was created.
VARCHAR2:
Stores strings of variable length.
The length parameter specifies the maximum length of the strings
It stores up to 4000 bytes of characters
It will not occupy space for NULL values
The total length of strings is defined when strings are given.

Answer / atul

i am not satisfied to all answers because if we say that
vsize() both are give same answer pls clear my doubt .

thanks to above suggestion/ans.

Answer / deepak gupta

Thanks Shishal

postfix expression for x^y^z-m+n+p/q ?

0 Answers   Cognizant,

How does Earthquake-proofing work?

0 Answers  

Tell me all about production of drought and its losses In the boiler?

0 Answers   Dairy Science College,

b. how the type of transmission medium can affect the performance of a network

2 Answers  

Paul the octopus who has been forecasting the outcome of FIFA world cup matches with tremendous accuracy has now been invited to predict ICC world cup matches in 2011. We will assume that the world cup contenders have been divided into 2 groups of 9 teams each. Each team in a group plays the other teams in the group. The top two teams from each group enter the semi finals ( after which the winner is decided by knockout). However, Paul has a soft spot for India and when India plays any team, Paul always backs India. Alas, his predictions on matches involving India are right only 2 out of 3 times. In order to qualify for the semi finals, it is sufficient for India to win 7 of its group matches. What is the probability that India will win the ICC world cup?

1 Answers   TCS,

How to configure gigabit port in 2950

3 Answers   Cisco,

I am about to face the interview panel of Indian army for UES(for more details put this address http://www.freshershome.com/jobs/index.php?post_id=15715) This is basically a post for engineering job in Indian army? This is an on campus interview. Kindly help me out with some tips or the type of questions I am about to face. Thanks.

5 Answers   Indian Army, Indian Military Services, Infosys, Military Engineer Services, UES,

A polynomials in mamory can be represented by____________

0 Answers  

what is the purpose of expansion tank in closed cooling water system?

3 Answers  

Hi friends..cud any help to get QC 9.2 trial..i tried with HP site but did'nt got it..please help me out

0 Answers  

I want to prepare for PSU's bt i dont know how many PSU's are open for computer science students and what is the competition level for these. So if anybody knows this please guide me through this.

0 Answers  

why we need embedded system

0 Answers