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 / deepu
ALTER VIEW = CREATE OR REPLACE VIEW
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the types of exception?
What are the various oracle database objects?
How to create a table interactively?
What is a system tablespace and when it is created?
Explain the use of owner option in exp command.
What is background process in Oracle?
How to update values in a table in oracle?
Can we write insert statement in function in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
what is the difference between data migration and production migration.
What happens if the update subquery returns multiple rows?
What is the oracle implicit cursor?
How to lock and unlock a user account in oracle?
What do you mean by redo log file mirroring?
Explain view?