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

which are the books available in, India for STONE COLUMNS/GRANULAR PILES?

0 Answers  

Why viruses wont affect Linux systems?

1 Answers  

Hi Friends, I am doing engg in comp sc in the final year from the evening college, I don't have experience in technical field. I am working in nontechnical field. I have big question that will IT companies considered me as fresher or they looks experience from me ? if you reply to my query, i am really grateful to you

0 Answers  

write an algorithm in O(n) time for finding the kth smaalest element form an array of n elements , where n and k are entered by user

0 Answers  

Box 1 cotain odd value X or Y the box 2 =X i.e 7 or 12 box 3= Y has value 19 if X is 7 or 31 if x is 12 get even value X or Y Use any operator steps allowed 3.

0 Answers  

what is the channel capacity of a band-limited gaussian channel? is it is blog2(1+s/n) or not? if not what?

3 Answers   UGC NET,

sir , i am prparing for IOCL engineergin post please send me the old placement papers

0 Answers   IOCL,

Net app interview questions ============================ . Storage Fundamentals: - what is Raid? What are different kind of Raids? - Difference between all of Raids , Advantage of one raid over other - What are FCP & ISCSI, Difference between them. - FC Topologies, Iscsi commands - How to mount a Lun on Windows/Linux - NFS and CIFS - Difference between SAN, NAS and DAS - Different Backup methodologies, Snapshot, mirror, Disaster Recovery, High Availability, Cluster concepts 2. Network Fundamentals: - TCP/IP and ISO/OSI layers - What is DHCP, DNS, SNMP, Router, Hub, Switch, HTTPS , HTTP, telnet , ssh, rsh - Different SNMP versions (V1, V2, V3) - SNMP traps - Ipv4 and Ipv6 addressing 3. Database: - SQL queries, Joins (may ask you to write queries with complex joins) - Aggregate functions - Schemas, Tables, views (create, delete, alter, drop etc) 4. Testing - Bug tracking process, Types of Bugs - Difference between priority and Severity of Bug - Your best bug , what will you do when your bug is not fixed/rejected etc. - What is Functionality/Sanity/Stress/Upgrade & revert/Performance/negative/Release test/regression tests. How you have done these in your past projects. - Black box testing, grey box testing - May ask to write test cases on a given scenario - What is test plan and test summary/strategy document. Different sections in these documents. - SDLC, Test Lifecycle and approach to test a product (Given a product what different kind of testing you will do) 5. Perl ( in addition, you may be asked to write scripts on below areas) - Regular expressions - File/Directory Handling - Scalars, Arrays and Hashes - Packages and Modules - Use and require statements - Go through Net::Telnet, Net::SNMP, Net::SSH modules in perl

0 Answers   NetApp,

i want techical questions on c and java with code part

0 Answers  

Anyone have thesis paper about "Electrical Load Forecasting" . Or the web addresses where people usually upload their thesis paper except IEEE.

0 Answers  

question no. 4======Give a brief description of the following terms: a) Play head b) Symbol c) Tweening d) ActionScript e) Frame rate f) Library panel g) Masking h) Context – sensitive Property Inspector i) Bandwidth Profiler j) Frame Label

0 Answers  

What are mixers used for?

1 Answers