SQL> SQL> create view v1 as select * from garbage; create view v1 as select * from garbage * ERROR at line 1: ORA-00942: table or view does not exist SQL> create force view v1 as select * from garbage; Warning: View created with compilation errors. SQL>
969352 wrote:any error indicates something is wrong.
I am checking some web links related to my error :-
Here , they discussed some thing differently ..
* MAY I KNOW AM I RIGHT ? or ( SOMETHING GOES WRONG )*
But i got this error when updating a view ( View restricted with CHECK OPTION )
ORA-01779: cannot modify a column which maps to a non key-preserved table
969352 wrote:I do not understand why you are wasting time investigating SQL that no professional would ever deploy.
*" any error indicates something is wrong."*
So that i am asking help here to trouble shoot ..
I don't know or i can't guess what's was the problem ?
Could you please help me ?