Post reply

instead of triggers

  • March 24, 2013 at 8:23 am

    #272482

    I came across this example regarding instead of triggers

    CREATE OR REPLACE VIEW dept_employees AS

    SELECT dname, ename

    FROM emp, dept

    WHERE dept.deptno = emp.deptno

    /

    Now there they explained that

    "Normally this view would not be updatable, because the primary key of the

    department (dept) table (deptno) is not unique in the result set of the

    join view. "

    Can someone please explain as to what this statement tries to convey?

  • March 24, 2013 at 8:24 am

    #1600109

    That's Oracle code, not SQL Server, hence the explanation will be relevant to Oracle's behaviour. If you have a question on Oracle, you're better off asking on an Oracle forum, not here.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply