i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---

How many types of segments in Oracle?

0 Answers   MCN Solutions,

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

0 Answers  

---

what is insert all statement in sql

2 Answers   CGI, TCS,

---

what are views?

8 Answers   TCS,

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

0 Answers  

---

How to define an external table with a text file?

0 Answers  

---

What are Clusters ?

5 Answers   Amdocs, Infosys,

---

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'));

0 Answers   IBM,

---

How many anonymous blocks can be defined?

0 Answers  

---

Where do we use decode and case statements?

0 Answers  

---

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

---