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

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

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is oracle and what are its different editions?

1007

How to execute a stored program unit?

1004

What is oracle instant client?

970

What is a trigger oracle?

1037

Explain what are the advantages of views?

1013

What do you mean by merge in oracle and how can we merge two tables?

1001

What is the usage of merge statement?

1095

How to create id with auto_increment on oracle?

932

What is transport network substrate (tns) in oracle?

992

Explain the use of tables option in exp command.

1052

How to define an anonymous procedure with variables?

1060

What is index in Oracle?

1009

How to increment dates by 1 in oracle?

990

What is recycle bin in Oracle?

1085

What is an oracle database table?

959