dropping and recreating of view is not i am expecting..

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

Question Posted / prasad_dwh09

4 Answers
7676 Views
CGI, I also Faced
E-Mail Answers

Answer Posted / prasad_dwh09

dropping and recreating of view is not i am expecting..

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is set operator oracle?

968

What is data block in Oracle?

1110

What is the usage of save points in oracle database?

959

What is a lookup table in oracle?

967

Explain table?

1104

Explain joins in oracle?

1027

How do you tell what your machine name is and what is its IP address?

2088

What are the extensions used by oracle reports?

1031

How to display employee records who gets more salary than the average salary in the department?

1060

What is a cognitive schema?

957

Which are the five query types available in oracle?

947

What is the difference between postgresql and oracle?

1036

Can sub procedure/function be called recursively?

991

What to do if the binary spfile is wrong for the default instance?

1061

What is define in oracle?

1056