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

How to use like conditions in oracle?

1111

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2305

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2144

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2342

How to rename a tablespace in oracle?

1123

What is program global area (pga) in oracle?

1088

How to update a table row with a record?

1063

What are transaction isolation levels supported by oracle?

1112

What is transport network substrate (tns) in oracle?

1091

How to invoke the data pump import utility?

1224

How to connect to a local oracle 10g xe server?

1032

Why do we use bulk collect in oracle?

1104

What are the uses of linked server and explain it in detail?

1117

What is a tns file?

1040

what is the use of system.effective.date variable in oracle?

1161