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
7678 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 are actual and formal parameters?

1102

What is primefaces used for?

1045

How to bring a tablespace online?

1069

if you ctreate table identity

2366

How do we represent comments in oracle?

1042

20. Using a set operator, display the client number of all clients who have never placed an order.

2179

How do we get field detail of a table?

1071

How to drop a tablespace?

1039

Which is faster join or subquery in oracle?

983

Explain a private synonyms?

1028

Can I create users through internet explorer in oracle 10g?

1075

Give the various exception types.

987

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2287

Please explain compound trigger in oracle?

1051

What is an anonymous block?

1228