Oracle SQL Table says Missing Right Parenthesis on Create Statement Why? [duplicate]












0















This question already has an answer here:




  • “Missing right parenthesis”: On Delete Set Null On Update Cascade (SQL/Oracle) [closed]

    1 answer



  • SQL Keep getting error with ON UPDATE CASCADE

    2 answers



  • how to use cascade in oracle

    1 answer



  • getting error ORA-00907 while creating a table in sql developer

    1 answer




CREATE TABLE Edit 
(
editID numeric(5) PRIMARY KEY ,
CONSTRAINT edit_fk FOREIGN KEY (adminID)
REFERENCES Admin (adminID)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT edit_fk FOREIGN KEY (flgihtID)
REFERENCES Flight (flightID)
ON DELETE CASCADE
ON UPDATE CASCADE
);

CREATE TABLE Reservation
(
reservationID numeric(5) PRIMARY KEY,
CONSTRAINT reservation_fk FOREIGN KEY (flightID)
REFERENCES Flight (flightID)
ON DELETE CASCADE
ON UPDATE CASCADE
);









share|improve this question















marked as duplicate by a_horse_with_no_name oracle
Users with the  oracle badge can single-handedly close oracle questions as duplicates and reopen them as needed.

StackExchange.ready(function() {
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function() {
$hover.showInfoMessage('', {
messageElement: $msg.clone().show(),
transient: false,
position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
dismissable: false,
relativeToBody: true
});
},
function() {
StackExchange.helpers.removeMessages();
}
);
});
});
Nov 22 at 20:19


This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.




















    0















    This question already has an answer here:




    • “Missing right parenthesis”: On Delete Set Null On Update Cascade (SQL/Oracle) [closed]

      1 answer



    • SQL Keep getting error with ON UPDATE CASCADE

      2 answers



    • how to use cascade in oracle

      1 answer



    • getting error ORA-00907 while creating a table in sql developer

      1 answer




    CREATE TABLE Edit 
    (
    editID numeric(5) PRIMARY KEY ,
    CONSTRAINT edit_fk FOREIGN KEY (adminID)
    REFERENCES Admin (adminID)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
    CONSTRAINT edit_fk FOREIGN KEY (flgihtID)
    REFERENCES Flight (flightID)
    ON DELETE CASCADE
    ON UPDATE CASCADE
    );

    CREATE TABLE Reservation
    (
    reservationID numeric(5) PRIMARY KEY,
    CONSTRAINT reservation_fk FOREIGN KEY (flightID)
    REFERENCES Flight (flightID)
    ON DELETE CASCADE
    ON UPDATE CASCADE
    );









    share|improve this question















    marked as duplicate by a_horse_with_no_name oracle
    Users with the  oracle badge can single-handedly close oracle questions as duplicates and reopen them as needed.

    StackExchange.ready(function() {
    if (StackExchange.options.isMobile) return;

    $('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
    var $hover = $(this).addClass('hover-bound'),
    $msg = $hover.siblings('.dupe-hammer-message');

    $hover.hover(
    function() {
    $hover.showInfoMessage('', {
    messageElement: $msg.clone().show(),
    transient: false,
    position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
    dismissable: false,
    relativeToBody: true
    });
    },
    function() {
    StackExchange.helpers.removeMessages();
    }
    );
    });
    });
    Nov 22 at 20:19


    This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


















      0












      0








      0








      This question already has an answer here:




      • “Missing right parenthesis”: On Delete Set Null On Update Cascade (SQL/Oracle) [closed]

        1 answer



      • SQL Keep getting error with ON UPDATE CASCADE

        2 answers



      • how to use cascade in oracle

        1 answer



      • getting error ORA-00907 while creating a table in sql developer

        1 answer




      CREATE TABLE Edit 
      (
      editID numeric(5) PRIMARY KEY ,
      CONSTRAINT edit_fk FOREIGN KEY (adminID)
      REFERENCES Admin (adminID)
      ON DELETE CASCADE
      ON UPDATE CASCADE,
      CONSTRAINT edit_fk FOREIGN KEY (flgihtID)
      REFERENCES Flight (flightID)
      ON DELETE CASCADE
      ON UPDATE CASCADE
      );

      CREATE TABLE Reservation
      (
      reservationID numeric(5) PRIMARY KEY,
      CONSTRAINT reservation_fk FOREIGN KEY (flightID)
      REFERENCES Flight (flightID)
      ON DELETE CASCADE
      ON UPDATE CASCADE
      );









      share|improve this question
















      This question already has an answer here:




      • “Missing right parenthesis”: On Delete Set Null On Update Cascade (SQL/Oracle) [closed]

        1 answer



      • SQL Keep getting error with ON UPDATE CASCADE

        2 answers



      • how to use cascade in oracle

        1 answer



      • getting error ORA-00907 while creating a table in sql developer

        1 answer




      CREATE TABLE Edit 
      (
      editID numeric(5) PRIMARY KEY ,
      CONSTRAINT edit_fk FOREIGN KEY (adminID)
      REFERENCES Admin (adminID)
      ON DELETE CASCADE
      ON UPDATE CASCADE,
      CONSTRAINT edit_fk FOREIGN KEY (flgihtID)
      REFERENCES Flight (flightID)
      ON DELETE CASCADE
      ON UPDATE CASCADE
      );

      CREATE TABLE Reservation
      (
      reservationID numeric(5) PRIMARY KEY,
      CONSTRAINT reservation_fk FOREIGN KEY (flightID)
      REFERENCES Flight (flightID)
      ON DELETE CASCADE
      ON UPDATE CASCADE
      );




      This question already has an answer here:




      • “Missing right parenthesis”: On Delete Set Null On Update Cascade (SQL/Oracle) [closed]

        1 answer



      • SQL Keep getting error with ON UPDATE CASCADE

        2 answers



      • how to use cascade in oracle

        1 answer



      • getting error ORA-00907 while creating a table in sql developer

        1 answer








      oracle ddl create-table






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 22 at 20:16









      a_horse_with_no_name

      291k46445539




      291k46445539










      asked Nov 22 at 19:26









      overwhelmed

      14




      14




      marked as duplicate by a_horse_with_no_name oracle
      Users with the  oracle badge can single-handedly close oracle questions as duplicates and reopen them as needed.

      StackExchange.ready(function() {
      if (StackExchange.options.isMobile) return;

      $('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
      var $hover = $(this).addClass('hover-bound'),
      $msg = $hover.siblings('.dupe-hammer-message');

      $hover.hover(
      function() {
      $hover.showInfoMessage('', {
      messageElement: $msg.clone().show(),
      transient: false,
      position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
      dismissable: false,
      relativeToBody: true
      });
      },
      function() {
      StackExchange.helpers.removeMessages();
      }
      );
      });
      });
      Nov 22 at 20:19


      This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.






      marked as duplicate by a_horse_with_no_name oracle
      Users with the  oracle badge can single-handedly close oracle questions as duplicates and reopen them as needed.

      StackExchange.ready(function() {
      if (StackExchange.options.isMobile) return;

      $('.dupe-hammer-message-hover:not(.hover-bound)').each(function() {
      var $hover = $(this).addClass('hover-bound'),
      $msg = $hover.siblings('.dupe-hammer-message');

      $hover.hover(
      function() {
      $hover.showInfoMessage('', {
      messageElement: $msg.clone().show(),
      transient: false,
      position: { my: 'bottom left', at: 'top center', offsetTop: -7 },
      dismissable: false,
      relativeToBody: true
      });
      },
      function() {
      StackExchange.helpers.removeMessages();
      }
      );
      });
      });
      Nov 22 at 20:19


      This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


























          1 Answer
          1






          active

          oldest

          votes


















          0














          There is no such thing as ON UPDATE CASCADE in Oracle. There might be in other RDMBSs, but not Oracle. Take that clause out.






          share|improve this answer




























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            There is no such thing as ON UPDATE CASCADE in Oracle. There might be in other RDMBSs, but not Oracle. Take that clause out.






            share|improve this answer


























              0














              There is no such thing as ON UPDATE CASCADE in Oracle. There might be in other RDMBSs, but not Oracle. Take that clause out.






              share|improve this answer
























                0












                0








                0






                There is no such thing as ON UPDATE CASCADE in Oracle. There might be in other RDMBSs, but not Oracle. Take that clause out.






                share|improve this answer












                There is no such thing as ON UPDATE CASCADE in Oracle. There might be in other RDMBSs, but not Oracle. Take that clause out.







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 22 at 19:59









                eaolson

                8,16163145




                8,16163145















                    Popular posts from this blog

                    Berounka

                    Sphinx de Gizeh

                    Different font size/position of beamer's navigation symbols template's content depending on regular/plain...