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

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

How to create a new user account in oracle?

778


What is a private synonym?

1300


What is a sub query? What are its various types?

790


What happens if variable names collide with table/column names?

823


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1625


How many types of tables are there in oracle?

800


When do you get a .pll extension in oracle?

907


Is there any function in oracle similar like group_concat of mysql?

793


What is an oracle and why it is used?

830


Where is the export dump file located?

782


What is connection pool in oracle?

737


What is the relation of a user account and a schema?

864


How to view existing locks on the database?

770


How do I connect to oracle database?

732


Can we create database in oracle using command line ?

802