View Single Post
  #1  
Old 12-03-2009, 04:54 AM
.BZU.'s Avatar
.BZU. .BZU. is offline


 
Join Date: Sep 2007
Location: near Govt College of Science Multan Pakistan
Posts: 9,693
Contact Number: Removed
Program / Discipline: BSIT
Class Roll Number: 07-15
.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute
Lightbulb What is the difference between char,varchar2? Oracle table creation

Char is stored as a fixed length string, Varchar2 is stored as a variable
length string. Thus, if you define the table:
Code:
create table mytable (
charfield Char(50),
varfield Varchar2(50));
If you perform the following insert: Insert Into mytable
(charfield,varfield) Values ('Hello','Hello');
The first fields will take 50 bytes while second will take only 5. It is
usually recommended to store strings as varchar.
__________________
(¯`v´¯)
`*.¸.*`

¸.*´¸.*´¨) ¸.*´¨)
(¸.*´ (¸.
Bzu Forum

Don't cry because it's over, smile because it happened
Reply With Quote