Skip to main content
Question

Updated Views

  • Jul 29, 2021 7:59 PM UTC
  • 4 replies
  • 19 views

miiclaudia

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

4 replies

SruthiA
Forum|alt.badge.img+1
  • Participating Frequently
  • Jul 29, 2021 8:31 PM UTC

@miiclaudia : you cannot update the view. you need to drop it and recreate view by adding 2 columns that you want to add.


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Jul 29, 2021 8:51 PM UTC

Can't you do a CREATE OR REPLACE VIEW?


miiclaudia
  • Author
  • New Participant
  • Jul 30, 2021 1:03 AM UTC

Dear Jim, the case is not permit include the new two fields in Create or replace view. =(


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Jul 30, 2021 10:58 AM UTC

@miiclaudia - Not sure what you mean. Do you not have the database privileges to run a CREATE OR REPLACE VIEW?