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

Difference between varchar and varchar2 data types?

1114

What is oracle thin client?

967

What privilege is needed for a user to delete rows from tables in another schema?

1017

What are the attributes that are found in a cursor?

1010

Explain oracle’s server parameter file.

946

What is SQL Tuning Advisor in Oracle?

1105

How to drop an index?

904

What are the differences between blob and clob in oracle?

1028

What is a dead lock in oracle?

1044

Explain the use of show option in imp command.

1037

What is tns service name?

1068

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1321

What are the components of logical database structure in oracle database?

1020

What is oracle database client?

973

What is tns entry?

1058