CREATE OR REPLACE VIEW VIEW_NAME AS SELECT COL1,COL2,REQ

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

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

Answer Posted / venki

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

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an external table?

957

How to use an explicit cursor without open statements?

1012

Explain the use of analyse option in exp command.

1064

Why is oracle used?

879

How to fetch the row which has the max value for a column?

947

How do we get field detail of a table?

1020

What is oracle server autotrace in oracle?

1089

What is null value in oracle?

1035

How can we find out the current date and time in oracle?

1034

What is the oracle implicit cursor?

998

What is a data lock in oracle?

1015

What is dynamic proxy?

959

What do you understand by a database object?

987

How to convert numbers to characters in oracle?

967

What happens in oracle commit?

970