Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between VARCHAR and VARCHAR2?
- 5 Answers
- 23768 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 .
| Is This Answer Correct ? | 27 Yes | 12 No |
Post New Answer View All Answers
what is polymorphism.
what is disadvantages of waterfall model ?? industry used which model ??
what do you expect from this company?
Anyone have thesis paper about "Electrical Load Forecasting" . Or the web addresses where people usually upload their thesis paper except IEEE.
tell me one scenario where we go for idoc and WHy we go for idoc.
Why we use 4 - 20 ma?
Suppose you want to form a conceptual model of UML.What elements would you require for this purpose?
What is the significance of superconductors?
How we can read an Image in VC++?How we can find out the intensities of the pixels of an image and dimension of the image?
No. of rounds: 1. GD 2. Written test 3. Technical round 4. HR Group Discussion: In GD I got topic “Effect of Movies on Youth, is it good or bad?”. Everyone got chance to speak. They examined the fluency and point of view on topic. I was selected in this round. Written Test: In written, there were 30 to 40 question including 5 subjective, they are, 1 What is RTTI(Run Time Type Information)? 2 What is containership? 3 What is the difference between compiler level of C++, C# and one other language? 4 Why C++ reserve 2 bytes for structure? 5 One question was related to dot net….. Remaining question are objective and they are belongs to C, Data Structure, 4-5 question from Java and also some questions from Software Development, includes, Some programs given with there output, questions related to sorting algorithm and there complexities, from java, multithreading and a program for Concatenation of two strings using inbuilt methods, from Software development they ask about software lifecycle(including all phases), specification and testing. It was all technical and I cleared the written too. Technical round: In this round, they asked about my resume. Remember the things that you write only those things in resume, in which you are very well, else it will create problems for you. They asked first about myself, and then about my programming skills. They give me a problem to solve in C. They ask me about SQL commands (because I mentioned in resume) like difference between delete and truncate, left join with syntax, then some questions from OS and computer network. I also found out that they were taking my stress testing. They fired questions very rapidly. Don’t give up they will make you feel free environment if you will get nervous (at that time I was). HR round: In this round as usual they asked about personal question to starting with about yourself. They asked some IQ questions like which object with four points are at equidistance, draw three co-centric circle without pull-up your hand, they also asked question, if a bear is jump from 1 meter in …sec. what is the color of that bear. Answer is related to measuring gravity according to south and north pole, and I was confused at that time. They also asked the meaning of my name, I gave that answer.
what is the difference between verification and validation
Please help to write testcase for ECG machine
what things abutsbi
sir i m reject two time in u.s in spring intake now im taking a date of 1july-2010 in fall intake &im competed my bachlor degree(chem) in jun-2009 so what answer i give to visa officer ask me a what r u doing last 1-year bcoz i have no work expirience
which/why unix commands are simpler rather than complex tasks
