Question: why am i getting an error in my sql code? my code: ALTER TABLE student_class ADD CONSTRAINT student_class_classcode_fk FOREIGN KEY (classcode); mye error: Error starting

why am i getting an error in my sql code?

my code:

ALTER TABLE student_class ADD CONSTRAINT student_class_classcode_fk FOREIGN KEY (classcode);

mye error:

Error starting at line : 53 in command - ALTER TABLE student_class ADD CONSTRAINT student_class_classcode_fk FOREIGN KEY(classcode)

Error report - SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword"

*Cause:

*Action:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

home / study / engineering / computer science / computer science questions and answers / please do not spam answer me like other chegg people ... Question: Please do not spam answer me like other...

Q:

home / study / engineering / computer science / computer science questions and answers / please do not spam answer me like other chegg people ... Question: Please do not spam answer me like other...

Q:

home / study / engineering / computer science / computer science questions and answers / please do not spam answer me like other chegg people ... Question: Please do not spam answer me like other...

Q:

home / study / engineering / computer science / computer science questions and answers / please do not spam answer me like other chegg people ... Question: Please do not spam answer me like other...

Q:

Here is a incomplete pos server program, receiving input from posclient, inserting traction detail data into sql database. create a database Client Server Program Search TMA02 in POSServer.java, to...

Q:

Why am I getting this constraint error when I try and run my ETL? Using SQL server When I create my DwPubsSales database these are the FK's I coded in /****** Add Foreign Keys ******/ Alter Table...

Q:

Hello, in this problem I only need numbers 16 and 17 finished, and if you see anything else wrong feel free to change. (only change under "// Type your code here") In PHP 3 --> 3. Problem Description...

Q:

SQL Primary and Foreign Key Tables already created and data in them. Unable to use the alter SQL because of null values: Alter table returns add primary key (return_id) I was able to add primary key...

Q:

True-False Questions 1. Normalizing accounting data refers primarily to eliminating errors and outliers, thus creating ?normal data.? 2. An important reason for normalizing data is to eliminate data...

Q:

needed a bit of help on the ones I got wrong or why I got them wrong I wasnt given an ER diagram to do this. this was all the information I received. Question 1 0/2 points In order to be used as a...

Q:

An exit poll is taken of 3000 voters in a statewide election. Let X denotes the number who voted in favor of a special proposition designed to lower property taxes and raises the sales tax. Suppose...

Q:

Vietnam and Japan can produce rice. Suppose the inducement costs of producing commercial-grade rice in Vietnam and Japan are $400 and $450 respectively. Additionally, Vietnamese farmers can produce...

Q:

14.20 What purchases will be made? A poll of 811 adults aged 18 or older asked about purchases that they intended to make for the upcoming holiday season.5 One of the questions asked what kind of...

Q:

Detailed operational plan for incorporating johnson and johnson Supply chain to provide management services and increase efficiency Objective Strategies Time frame for completion Accountable team...

Q:

Did you get sign-offs from clients, bosses, stakeholders, and anyone else in the process?

Q:

3. Raster images for screen projects need to be 72 dpi to scale.

Q:

apply communication design concepts into creative projects. understand digital color.