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.

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.

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

which is best insttute for teradata,sybase,mysql,oracle in hyderabad

1 Answers  

---

Explain do view contain data?

0 Answers  

---

What are the advantages of oracle?

0 Answers  

---

Can a formula column be obtained through a select statement ?

0 Answers   Oracle,

---

What is a Shared SQL pool ?

2 Answers  

---

How to apply filtering criteria at group level in oracle?

0 Answers  

---

How to list all user accounts in oracle?

0 Answers  

---

How to define default values for formal parameters?

0 Answers  

---

what is a Nested Loop join?

0 Answers  

---

Is oracle a relational database?

0 Answers  

---

what r routers?

1 Answers  

---