ALTER VIEW = CREATE OR REPLACE VIEW

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

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

Answer Posted / deepu

ALTER VIEW = CREATE OR REPLACE VIEW

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to find out what oracle odbc drivers are installed?

1040

What is a procedure in oracle?

1197

How to check the server version in oracle?

1092

How to download oracle database 10g xe?

1018

Is oracle a language?

946

Why does for update in oracle 8 cause an ora-01002 error?

1003

What is Library Cache in Oracle?

1142

What is the purpose of save points in oracle database?

1118

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2179

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2220

Which is better Oracle or MS SQL? Why?

4943

Explain the blob datatype?

1071

Please explain compound trigger in oracle?

1057

Is there a combination of "like" and "in" in sql?

1065

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2008