Concepts and Architecture Question:

Download Job Interview Questions and Answers PDF

Can we add a column to view in Oracle?

Oracle Architecture and Concepts Interview Question
Oracle Architecture and Concepts Interview Question

Answer:

No, you cant ALTER VIEW to add or remove columns.
Need to recreate view with new column using CREATE OR REPLACE view command

Download Oracle Architecture and Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
What is a Data Segment in Oracle?Which parameter specifies the number of DBWn processes?