i can create a view with two columns from emp table,, later i need to add one

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
6917 Views
CGI, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i can create a view with two columns from emp table,, later i need to add one more emp column to e..

Answer / raghavendra

create or replace view <view_name> as select * from emp;

or you can provide the columns in select command

Is This Answer Correct ?

5 Yes

0 No

i can create a view with two columns from emp table,, later i need to add one more emp column to e..

Answer / venki

CREATE OR REPLACE VIEW VIEW_NAME AS SELECT COL1,COL2,REQ_COL
FROM EMP;

Is This Answer Correct ?

4 Yes

0 No

i can create a view with two columns from emp table,, later i need to add one more emp column to e..

Answer / prasad_dwh09

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

Is This Answer Correct ?

2 Yes

2 No

i can create a view with two columns from emp table,, later i need to add one more emp column to e..

Answer / deepu

ALTER VIEW = CREATE OR REPLACE VIEW

Is This Answer Correct ?

0 Yes

1 No

Post New Answer