⟩ Can we add a column to view in Oracle?
No, you cant ALTER VIEW to add or remove columns.
Need to recreate view with new column using CREATE OR REPLACE view command
No, you cant ALTER VIEW to add or remove columns.
Need to recreate view with new column using CREATE OR REPLACE view command
How To Look at the Current SQL*Plus System Settings?
What Is a Database Table in Oracle?
What Are SQL*Plus Environment Variables?
What Is a Table Index in Oracle?
What Is an Oracle Tablespace?
How To Generate Query Output in HTML Format?
What Is Output Spooling in SQL*Plus?
What Is an Oracle Data File?
How To Save Query Output to a Local File?
What Is a Static Data Dictionary in Oracle?