Concepts and Architecture Question:
Can we add a column to view in Oracle?
Answer:
No, you cant ALTER VIEW to add or remove columns.
Need to recreate view with new column using CREATE OR REPLACE view command
Need to recreate view with new column using CREATE OR REPLACE view command
| Previous Question | Next Question |
| What is a Data Segment in Oracle? | Which parameter specifies the number of DBWn processes? |