ALTER VIEW = CREATE OR REPLACE VIEW

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 / deepu

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

Answer Posted / deepu

ALTER VIEW = CREATE OR REPLACE VIEW

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is parameterized cursor in oracle?

1129

What is oracle server autotrace in oracle?

1156

What is an oracle cursor variable?

1058

What is the difference between 10g OEM and 11g OEM?

957

master table and child table performances and comparisons in Oracle ?

2130

How to create an oracle testing table?

1055

What is columnar storage what is the advantage?

1047

How to delete multiple rows from a table in oracle?

1052

Explain what are clusters?

1099

What are the limitations of check constraint?

1020

What is proxy method?

964

Is it possible to insert comments into sql statements return in the data model editor ?

2540

How many types of synonyms in Oracle?

1111

How to count groups returned with the group by clause in oracle?

1061

material view and view disadvantages?

1053