Having trouble resolving this problem

1

I have this code but I keep getting this ORA-10000
This the code I am working on

DROP TABLE STUDENT; 

CREATE TABLE STUDENT 

(  Student_ID NUMBER(5) NOT NULL ENABLE 

   ,F_NAME VARCHAR2(30) NOT NULL ENABLE 

   ,L_NAME VARCHAR2(30) NOT NULL ENABLE 

   ,HomePhone_Number NUMBER(10) 

   ,Home_Address     VARCHAR2(35) 

   ,City             VARCHAR2(35) 

   ,State            VARCHAR(2) 

   ,Zip_Code         NUMBER(5) 

   ,Spouse_FName     VARCHAR2(25) 

   ,Spouse_LName     VARCHAR2(25) 

   ,Enrolled_ID      NUMBER(10) 

   ,Academic_Advisor_ID NUMBER(5) 

   ,PRIMARY KEY (Student_ID) ENABLE 
); 

  

DROP TABLE FACULTY; 

CREATE TABLE FACULTY 
(   Faculty_ID           NUMBER(5) NOT NULL ENABLE 

   ,F_Name               VARCHAR2(30) NOT NULL ENABLE 

   ,L_Name               VARCHAR2(30) NOT NULL ENABLE 

   ,OfficePhone_Numnber  NUMBER(10) 

   ,Office_Number        NUMBER(10) 

   ,PRIMARY KEY (Faculty_ID) ENABLE 
); 

  

  

DROP TABLE ADVISOR; 

CREATE TABLE ADVISOR 

(  Student_ID  NUMBER(5), 

   Faculty_ID  NUMBER(5), 

   Advisor_TYPE VARCHAR2(20) 

); 

  

--INSERT VALUES INTO STUDENT 

INSERT INTO STUDENT VALUES 

(1,'Emily','Bronte',9542403843,'742 Evergreen Terrace','Springfield','IL',34567,'Jason','Bourne',1001); 

  

INSERT INTO STUDENT VALUES 

(2,'Alice','Walker',5481354795,'3584 NW 29th St','Mason','FL',17465,'Michael','Myers',1002); 

  

INSERT INTO STUDENT VALUES 

(3,'Kurt','Vonnegut',5481354796,'14 Blanchfield','Summer','FL',12444,'Jane','Vonnegut',1003); 

  

INSERT INTO STUDENT VALUES 

(4,'Isaac','Asimov',5481354743,'6754 N Riva Ridge Loop','Evans Mills','NY',13602,'April','Asimov',1004); 

  

INSERT INTO STUDENT VALUES 

(5,'Thomas','Elliot',5481354799,'6754 W Riva Ridge Loop','Evans Mills','NY',13602,'Sara','Elliot',1005); 

  

INSERT INTO STUDENT VALUES 

(6,'Louisa','Alcott',5481357117,'6754 S Riva Ridge Loop','Evans Mills','NY',13602,'Freddy','Alcott',1006); 

  

  

--INSERT VALUES INTO FACULTY 

  

INSERT INTO FACULTY VALUES(500,'Marth','Graham'); 

INSERT INTO FACULTY VALUES(501,'Mikhail','Baryshinokov'); 

INSERT INTO FACULTY VALUES(502,'Jerome', 'Robbins'); 

INSERT INTO FACULTY VALUES(503,'Arthur', 'Mitchell'); 

INSERT INTO FACULTY VALUES(504,'Kir','Jooss'); 

  

--INSERT VALUES INTO ADVISOR 

  

INSERT INTO ADVISOR VALUES( 1, 500, 'Academic Advisor'); 

INSERT INTO ADVISOR VALUES( 2, 501, 'Academic Advisor'); 

INSERT INTO ADVISOR VALUES( 3, 502, 'Academic Advisor'); 

INSERT INTO ADVISOR VALUES( 4, 503, 'Academic Advisor'); 

INSERT INTO ADVISOR VALUES( 5, 504, 'Academic Advisor'); 

INSERT INTO ADVISOR VALUES( 1, 502, 'Thesis Advisor'); 

INSERT INTO ADVISOR VALUES( 2, 504, 'Thesis Advisor'); 

INSERT INTO ADVISOR VALUES( 3, 503, 'Thesis Advisor'); 

INSERT INTO ADVISOR VALUES( 4, 501, 'Thesis Advisor'); 

INSERT INTO ADVISOR VALUES( 5, 500, 'Thesis Advisor'); 

  

COMMIT; 

  

SET AUTOTRACE ON; 

  

--QUERY : All students under a specific advisor 

SELECT FACULTY.Faculty_ID,FACULTY.F_Name,FACULTY.L_Name,STUDENT.Student_ID,F_Name,L_Name 

FROM STUDENT,FACULTY,ADVISOR 

WHERE (STUDENT.STUDENT_ID = ADVISOR.STUDENT_ID) AND 

(FACULTY.Faculty_ID = ADVISOR.Faculty_ID) 

ORDER BY FACULTY.Faculty_ID; 

  

CREATE UNIQUE INDEX index_name 

ON ADVISOR(Student_ID,Faculty_ID); 

  

SET AUTOTRACE ON; 

  

--QUERY : All students under a specific advisor 

SELECT FACULTY.Faculty_ID,FACULTY.F_Name,FACULTY.L_Name,STUDENT.Student_ID,F_Name,L_Name 

FROM STUDENT,FACULTY,ADVISOR 

WHERE (STUDENT.Student_ID = ADVISOR.Student_ID) AND 

(FACULTY.Faculty_ID = ADVISOR.Faculty_ID) 

ORDER BY FACULTY.Faculty_ID;
2

I’ve edited your post for readability. When you enter a code block into a forum post, please precede it with a separate line of three backticks and follow it with a separate line of three backticks to make it easier to read.

See this post to find the backtick on your keyboard. The “preformatted text” tool in the editor (</>) will also add backticks around text.

Note: Backticks are not single quotes.

markdown_Forums