Updated Views
Hi All
I have an issue in the views when i trying to do an updated in one view. My wish is include two columns more in one view but is too impossible and the data point send me error.
Thanks in advanced
Tagged:
0
Hi All
I have an issue in the views when i trying to do an updated in one view. My wish is include two columns more in one view but is too impossible and the data point send me error.
Thanks in advanced
Answers
@miiclaudia : you cannot update the view. you need to drop it and recreate view by adding 2 columns that you want to add.
Can't you do a CREATE OR REPLACE VIEW?
Dear Jim, the case is not permit include the new two fields in Create or replace view. =(
@miiclaudia - Not sure what you mean. Do you not have the database privileges to run a CREATE OR REPLACE VIEW?