dropping and recreating of view is not i am expecting..

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

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

Answer Posted / prasad_dwh09

dropping and recreating of view is not i am expecting..

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why cursor variables are easier to use than cursors?

1099

What is SQL Tuning Advisor in Oracle?

1186

Explain the function of optimizer in oracle?

1149

What is data type in oracle?

1129

How to add a new column to an existing table in oracle?

1143

What is an oracle data file?

1110

Can we store pictures in the database and if so, how it can be done?

1047

How to sort the query output in oracle?

1032

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1122

How to declare a local variable?

1131

How to load a large xml file?

1060

How many types of auditing in Oracle?

1037

Explain table?

1123

Is the After report trigger fired if the report execution fails ?

2920

State and explain about oracle instance?

1003