Re: Updateable view--How to see if it is?

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1996/12/14
Message-ID: <32B2EF8F.386E@qrcsun.qrc.org>#1/1

Steve Cosner wrote:
>
> What is the mose efficient method to determine whether a view is
> updateable or display-only?

There are several view to determine the updateable columns:

USER_UPDATABLE_COLUMNS, DBA_UDATABLE_COLUMNS, ALL_UPDATABLE_VIEWS.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Sat Dec 14 1996 - 00:00:00 CST

This message: [ Message body ]
Next message: Dave Schweisguth: "SQL*Plus login.sql in other than my current directory?"
Previous message: Steve Cosner: "Updateable view--How to see if it is?"
In reply to: Steve Cosner: "Updateable view--How to see if it is?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US