Skip to main content
Question

Updated Views

  • July 29, 2021
  • 4 replies
  • 7 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
  • July 29, 2021

@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
  • July 29, 2021

Can't you do a CREATE OR REPLACE VIEW?


miiclaudia
  • Author
  • New Participant
  • July 30, 2021

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
  • July 30, 2021

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