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
What is connection pool in oracle?
Explain a private synonyms?
How can we find out the current date and time in oracle?
Why does for update in oracle 8 cause an ora-01002 error?
What are the benefits of ordbms?
How to use subqueries with the exists operator in oracle?
What are the ways tablespaces can be managed and how do they differ?
Is it possible to insert comments into sql statements return in the data model editor ?
What is the implicit cursor in oracle?
What is bulk load in oracle?
Explain about your project and its relation to the current job position you are applying to?
What language does oracle use?
How are extents allocated to a segment?
What is meant by recursive hints in oracle?
What is oracle used for?