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.

What are named parameters?

0 Answers  

---

Explain the use of parfile option in exp command.

0 Answers  

---

candidate key is subset of super key but not vice-verse explain

0 Answers  

---

List the parts of a database trigger.

0 Answers  

---

What are the common oracle dba tasks?

0 Answers  

---

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 Answers  

---

Explain the use of owner option in exp command.

0 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

0 Answers  

---

What is procedure overloading in oracle?

0 Answers  

---

What is the parameter mode that can be passed to a procedure?

0 Answers  

---

What is transport network substrate (tns) in oracle?

0 Answers  

---

Explain an exception?

0 Answers  

---