By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
SQL> create view contact 2 as select contact, name, phone 3 from publisher; View created. SQL> alter view contact (contact, name, phone 2 as select contact, name, phone 3 from publisher 4 with read only; alter view contact (contact, name, phone) * ERROR at line 1: ORA-00922: missing or invalid option
Dig Deeper on Using Oracle PL-SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.