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
How to create additional tablespaces for an new database?
How do I reset a sequence in oracle?
Explain joins in oracle?
Is primary key indexed by default in oracle?
What are the uses of linked server and explain it in detail?
How to use null as conditions in oracle?
What are the different windows events activated at runtime ?
What is the difference between online and offline backups?
What is the scope of a local variable?
How to run queries on external tables?
What are the data types in oracle?
State some uses of redo log files?
How to convert raw data type into text in oracle? Explain
How to open a cursor variable?
definition of cluster and non-clustered index?