Interested to Buy Any Domain ? << Click Here >> for more details...
hai,
when to use char and varchar2....?
- 2 Answers
- 4996 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gangaram
char- should be use when you know that the number of
characters in the coloumn field is constant .ex if the
gender is coloumn with char(1)- so only M and F are the two
options so char(1) is better to use than varchar2.
varchar2- first of all varchar2 is a oracle standard.
varchar2 is nothing but variable characters.
ex- if you have defined the column with varchar2(50) and
when u r inserting the record into that column with only 10
letter/characters then only 10 bits will be used instead of
50.
but if u declare char(50) full 50 bits is allocated for
that column. so even if u enter on 20 characters the space
utilized will be full 50 bits.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / kranthi
char and varchar2 both we will use for character purpouse
only.but char take how many bytes we r specified in data
type size it will take that much of size.
eg: x char(10);
x:='nani' the remaining 6 character space will b wasted.
but in varchar2 we can use that 6 bytes for another
character also.
i hope so u under stood very well.
| Is This Answer Correct ? | 7 Yes | 0 No |
Explain rename?
What is logical backup in oracle?
How to assign values to variables?
What is system global area (sga) in oracle?
What is memory advisor in Oracle?
1. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
select * from emp what happened internally when we write this query in the sql prompt?
What is a system tablespace?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
How to pass a parameter to a cursor in oracle?
How many data types are supported?
How to rename an index?
Oracle General 
