How to update a View?

Question

How to update a View?

Navigation

#1 by (1 votes)

0

I have a table where I check in and out of trucks. In this table there are two fields of type Date, I want to update the data of these fields. I'm using the following select.

  UPDATE V_TPL_ACOMPANHAMENTO SET E_POR = TO_DATE('08/10/18 22:24','DD/MM/YY HH24:MI'), 
  S_PORT = TO_DATE('09/10/18 01:55','DD/MM/YY HH24:MI') WHERE COLETA='EDB-TP-32764C'

But when I try to update, the error message appears: ORA-01732: data manipulation operation not legal on this view

sql oracle

asked by anonymous 16.10.2018 / 16:55

1 answer

convert varchar to date oracle plsql Validation DataAnnotation displaying message in English

score 1 · Accepted Answer

Cause: An attempt was made to use an UPDATE, INSERT, or DELETE statement on a view that contains expressions or functions, or was derived from more than one table. If a merge operation was used to create the view or the view contains virtual columns derived from functions or expressions, the view can only be queried. Source oracle documentation.