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

Why use resource manager in Oracle?

1107

Is there a function to split a string in plsql?

1062

Why do we use coalesce function in oracle?

1123

What is the difference between count (*), count (expression), count (distinct expression)?

1007

What is the difference between a hot backup and a cold backup in oracle?

1017

State some uses of redo log files?

1010

How to create a new user account in oracle?

1021

How to check the oracle tns settings?

1047

When do we use group by clause in a sql query?

1036

What is a connect identifier?

1040

Calculate difference between 2 date / times in oracle sql?

1041

What is a table index in oracle?

1131

Explain rename?

984

Does facebook use oracle?

1034

How to call a stored function with parameters?

1046