Question: why am i getting an error in my sql code? my code: CREATE TABLE class ( Classcode char (4), Class_description varchar (20) UNIQUE NOT NULL,

why am i getting an error in my sql code?

my code:

CREATE TABLE class (

Classcode char (4),

Class_description varchar (20) UNIQUE NOT NULL,

CREATE INDEX classdescription_idx ON class(classdescription);

my error: Error starting at line : 36 in command - CREATE INDEX classdescription_idx ON class(classdescription)

Error at Command Line : 36 Column : 57 Error report -

SQL Error: ORA-01408: such column list already indexed 01408. 00000 - "such column list already indexed"

*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:

Why am i getting an error on my SQL code? this is my code: CREATE TABLE dougl_class ( Classcode char (4), Class_description varchar (20) UNIQUE NOT NULL, ); This is my error message: Error starting...

Q:

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

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:

Hi, I am currently in an Intro to Database class and I am learning the basics of SQL at the moment. I am currently working on an assignment and I am getting an error for when I am entering values...

Q:

Web programming 1.) MySQL: a.) Write SQL commands to create a database called my_db (Imk) b.) Write SQL commands to create the following tables; ustomer (CustomerlD, Persons (PersonI , CustomerName,...

Q:

I need help with part F for drawing a UML class diagram for the Student class. I don't know how to create that diagram. Make sure that you list all of the fields and methods in the diagram. Also,...

Q:

TASK 1: MAKE UPDATES AND CORRECTIONS Based on Part 1 Comments-20 Points: 1. Update the data model: Make any required changes to your design based on the comments provided for Part 1 of the project....

Q:

REQUIRED: PLEASE ANSWER QUESTION NO. 7-10 Copy and paste the PL/SQL code on the space provided after each questions. Copy and paste the PARTS table CREATE TABLE PARTS( PARTNUM CHAR(4) PRIMARY KEY,...

Q:

Please, I need some help with this one. I have been trying to upload the question for two days now and the website will not let me upload the ScreenShots plus the code I have. I have been back &...

Q:

Use a command line argument for the input file for processing tokens Recognize the new tokens > void float Be sure to change token file appropriately and then run TokenSetup as required Include line...

Q:

The 24-in. pipe conducts water from reservoir A to a pressure turbine, which discharges through another 24-in. pipe into tailrace B. The loss of head from A to 1 is 5 times the velocity head in the...

Q:

The intention for investigating the project management software tools is to deploy them to assist your group in completion by enabling the teams activities relating to Initiating, Planning,...

Q:

Express each of the following numbers in standard form. (a) 85.300 (b) 52 700.000 (c) 0.000 23 (d) 0.000 000 0904

Q:

What is your opinion on the role of the use of US employment rules and regulation in other countries? Consider, for example, minimum age requirements, 4 0 hour work weeks, 1 5 minute breaks, minimum...

Q:

Assume that you have just been hired as the store manager for a high-volume discount store in Winnipeg. Other stores in Alberta are owned by the same person. The previous manager recently hired 10...

Q:

Since pay for performance is an important factor governing compensation increases, managers must be able to defend the compensation recommendations they make for their employees. Merit raises granted...

Q:

How do you think the other employees learned about Bobs salary? What could have been done to prevent this? Ravi Singh sat at his desk and wondered what his next steps should be. As the manager of the...