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
7532 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

Explain an exception and its types?

1008

What is merge statement used for?

964

How to loop through data rows in the implicit cursor?

1011

How to recover a dropped table in oracle?

983

What is a synonym? What are its various types?

1042

Explain the function of optimizer in oracle?

1046

How many categories of data types?

934

What is set verify off in oracle?

1028

What is Reduced List of Values?

2098

How to sort the query output in oracle?

967

How to create an oracle testing table?

1005

What is the database name in oracle?

967

Are truncate and delete commands same? If so why?

1072

What is the difference between "as" and "is" in an oracle stored procedure?

931

How to pass parameters to procedures?

970