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

How to rollback the current transaction in oracle?

1061

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1118

---

What is the difference between sharding and partitioning?

994

---

How to view all columns in an existing table?

941

---

Explain oracle left join with an example?

1018

---

How do I recompile a procedure in oracle?

971

---

What is the data pump export utility?

1089

---

What is memory advisor in Oracle?

1083

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1694

---

query optmization techniques and quwry analyser+projects+ppts

2426

---

What are the uses of a database trigger?

1001

---

Explain the use of rows option in exp command.

1100

---

Give syntax for SQL and ORACLE joins.

1099

---

11. Display the client number and name and the client number and name of the person who referred that client.

2344

---

What are the execution control statements in oracle?

1101

---