what is the difference between VARCHAR and VARCHAR2?
Answer Posted / 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.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
can u tell me what are the subjects involved in group I and II and how i prepare for the exam
HELLO EVERYONE ON YAHOO , I'M IN NIGERIA AND I Will LIKE TO MOVE AND WORK IN CANADA , ANY SKILLED WORK IS OK BY ME AND THE PERSON WILL PAY THE BILL FOR IT, I WILL SERVE THE PERSON FOR THE EXPENSES.......... LOVE TO READ FROM YOU SOONEST AS YOU WISH TO HELP ME OUT
there are 50 users in a network, one system is virus affected , how to find that virus affected system?
iam from engineering information technology ... can i write group 1 exams??
1.what a diffrenrs v-lan & (layer)l-3,l-2 bitween plz define defination of these? 2.how to configur ms outlook & lotus note (ibm)
15. What is your Future Plans for the Company if Permanently Employed?
write a programe to print this string in reverse order and find out how many times letter c is repeated? string = { c was desined by dennis ritchie}. also find out the lenth of the string.
A company canteen needs an automated system for its food and beverage management. The canteen receives food and beverage items from different distributors. All the non perishable items are stored in the store-room and the perishable items are put in the fridge. The manager should be able to add, delete or update food and beverage items onto the system and perishable and non perishable item details are to be stored separately. Both waiters and the cooks should be able to update the perishable items, but only the cooks should be allowed to update the non perishable items. Both cooks and waiters are not allowed to add or delete any items that are entered. identify the Schema, Table , Fields
BEL old probationary engineering questions and answers
Just a one miniute topics in English?
Write the fetch cycle and execute cycle for following instructions:JMPNZ (jump to the given address if the accumulator not equal to zero) RET(return from a subroutine) ADB (add the contents of register B to the accumulator and save result in the accumulator).
why u r shifting from engineering to other field ?
3. Tell me about a time when you had too many things to do and you were required to prioritize your tasks.
can anyone help me with an article or a few pointers on what are the industry expectations from Fresh engineers in today's market scenario
Are bridges more stable on concrete or on soil - why?