Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Are there any plans to implement INSTEAD OF triggers for views?

      An INSTED OF trigger is code that is executed instead of an INSERT, DELETE or UPDATE statement.
      This works for both tables and views.

      Syntax:

      CREATE TRIGGER [schema_name.] trigger_name
      ON

      {table_name | view_name }

      INSTEAD OF

      {[INSERT] [,] [UPDATE] [,] [DELETE] }

      AS

      {sql_statements}

      You can find some documentation about this at:
      https://www.sqlservertutorial.net/sql-server-triggers/sql-server-instead-of-trigger/
      https://www.oracletutorial.com/plsql-tutorial/oracle-instead-of-triggers/

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            Unassigned Unassigned
            balta Tadas BalaiĊĦis
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.