Oracle SQL Table says Missing Right Parenthesis on Create Statement Why? [duplicate]
Multi tool use
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
);
oracle ddl create-table
edited Nov 22 at 20:16
a_horse_with_no_name
291k46445539
asked Nov 22 at 19:26
overwhelmed
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.
add a comment |
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
);
oracle ddl create-table
edited Nov 22 at 20:16
a_horse_with_no_name
291k46445539
asked Nov 22 at 19:26
overwhelmed
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.
add a comment |
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
);
oracle ddl create-table
edited Nov 22 at 20:16
a_horse_with_no_name
291k46445539
asked Nov 22 at 19:26
overwhelmed
14
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
oracle ddl create-table
edited Nov 22 at 20:16
a_horse_with_no_name
291k46445539
asked Nov 22 at 19:26
overwhelmed
14
edited Nov 22 at 20:16
a_horse_with_no_name
291k46445539
asked Nov 22 at 19:26
overwhelmed
14
edited Nov 22 at 20:16
a_horse_with_no_name
291k46445539
edited Nov 22 at 20:16
a_horse_with_no_name
291k46445539
edited Nov 22 at 20:16
a_horse_with_no_name
291k46445539
291k46445539
asked Nov 22 at 19:26
overwhelmed
14
asked Nov 22 at 19:26
overwhelmed
14
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.
add a comment |
add a comment |
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.
answered Nov 22 at 19:59
eaolson
8,16163145
add a comment |
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.
answered Nov 22 at 19:59
eaolson
8,16163145
add a comment |
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.
answered Nov 22 at 19:59
eaolson
8,16163145
add a comment |
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.
answered Nov 22 at 19:59
eaolson
8,16163145
There is no such thing as ON UPDATE CASCADE in Oracle. There might be in other RDMBSs, but not Oracle. Take that clause out.
answered Nov 22 at 19:59
eaolson
8,16163145
answered Nov 22 at 19:59
eaolson
8,16163145
answered Nov 22 at 19:59
eaolson
8,16163145
answered Nov 22 at 19:59
eaolson
8,16163145
8,16163145
add a comment |
add a comment |
NwFUu0 SoAwMTpxzF3arGy0Ci,hceqtk,i,XIr9KlktO3DY3ZAp1Twy8JbBFsYOBd4dj
