hai,

when to use char and varchar2....?


















































Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create additional tablespaces for an new database?

570


How do I reset a sequence in oracle?

591


Explain joins in oracle?

559


Is primary key indexed by default in oracle?

540


What are the uses of linked server and explain it in detail?

584






How to use null as conditions in oracle?

578


What are the different windows events activated at runtime ?

2408


What is the difference between online and offline backups?

560


What is the scope of a local variable?

584


How to run queries on external tables?

565


What are the data types in oracle?

548


State some uses of redo log files?

554


How to convert raw data type into text in oracle? Explain

599


How to open a cursor variable?

602


definition of cluster and non-clustered index?

2475