what is the difference between VARCHAR and VARCHAR2?
Answer Posted / 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....
| Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
How to create test case scenario?
i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?
How do you reset or reseed the IDENTITY column?
If you were to drill a circular hole in a sheet of metal and then heat the sheet, what would happen to the size of the hole?
hi i am avinash ,i am doing ma b-tech(cse) final year and i have been detained for 2years due to attendance and i will be finished ma b-tech in 6 years ,plz tell me weather i will be eligible for government jobs like bhel, drdo,or any other private companies
hi,i came to US to pursue my masters in computer information technology.Can i do my masters the first 6months in US and the rest 9 months course from INDIA through online education
I an doing Engineering in IT(4th year). i want to know what is the scope or .NET and Linux, and which is better for carrier
How EVA granules manufactured (I wanted to know the manufacturing process). (Virgin Granules) and what are the Raw Materials used.
an upper layer message is split into 10 frames each of which has an 80 percent chance of arriving undamaged.if no error control is done by the data link protocol,how many times must the message be sent on the average to get the entire thing through?
What is the difference between a .PST file and a .OST file?
What is meant by STL?
what size shaft is required to transmit 100 hp @1000 RPM ,if max shear stress is 10,000 PSI,angle of twist must be less than 1' /ft/shaft is made of steel.
how many protocols are available and what are they?
what is the diffeence between SQL and ORACLE?
which is better php,asp.net,jsp? and why?