logo

Oracle Database Assignment | DBMS

7 Pages3576 Words478 Views
   

Added on  2019-09-16

Oracle Database Assignment | DBMS

   Added on 2019-09-16

ShareRelated Documents
Error starting at line : 1 in command -create table Project_Type(ptype_id integer primary key, ptype_name varchar(50))Error report -SQL Error: ORA-00955: name is already used by an existing object00955. 00000 - "name is already used by an existing object"*Cause: *Action:Error starting at line : 7 in command -insert into project_type(ptype_id, ptype_name) values (1, 'Web')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 8 in command -insert into project_type(ptype_id, ptype_name) values (2, 'Maintenance')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 9 in command -insert into project_type(ptype_id, ptype_name) values (3, 'App')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 10 in command -insert into project_type(ptype_id, ptype_name) values (4, 'Testing')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024374) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 13 in command -create table project(Project_idvarchar(10) primary key,Project_Namevarchar(100),
Oracle Database Assignment | DBMS_1
Project_Type_id integer, Start_Date date, End_Date date,expect_finish_date date,constraintp_fk foreign key(Project_Type_id) references Project_Type(ptype_id))Error report -SQL Error: ORA-00902: invalid datatype00902. 00000 - "invalid datatype"*Cause: *Action:Error starting at line : 24 in command -insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date, expect_finish_date) values ('B1049', 'Health System', 1, '2016-06-01', '2016-09-01', '2016-09-02')Error report -SQL Error: ORA-01861: literal does not match format string01861. 00000 - "literal does not match format string"*Cause: Literals in the input must be the same length as literals in the format string (with the exception of leading whitespace). If the "FX" modifier has been toggled on, the literal must match exactly, with no extra whitespace.*Action: Correct the format string to match the literal.Error starting at line : 26 in command -insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date, expect_finish_date) values ('B1050', 'insurance System', 2, '2016-01-01', '2016-03-03', '2016-03-06')Error report -SQL Error: ORA-01861: literal does not match format string01861. 00000 - "literal does not match format string"*Cause: Literals in the input must be the same length as literals in the format string (with the exception of leading whitespace). If the "FX" modifier has been toggled on, the literal must match exactly, with no extra whitespace.*Action: Correct the format string to match the literal.Error starting at line : 28 in command -insert into project(Project_id, Project_Name, Project_Type_id, Start_Date, End_Date, expect_finish_date) values ('B1051', 'university System', 3, '2016-05-01', '2016-06-01', '2016-06-05')Error report -SQL Error: ORA-01861: literal does not match format string01861. 00000 - "literal does not match format string"*Cause: Literals in the input must be the same length as literals in the format string (with the exception of leading whitespace). If the "FX" modifier has been toggled on, the literal must match exactly, with no extra whitespace.*Action: Correct the format string to match the literal.Error starting at line : 30 in command -create table Job_type(type_id varchar(5) primary key, type_name varchar(50))Error report -SQL Error: ORA-00955: name is already used by an existing object
Oracle Database Assignment | DBMS_2
00955. 00000 - "name is already used by an existing object"*Cause: *Action:Error starting at line : 36 in command -insert into job_type(type_id, type_name) values ('JT1', 'Imaging')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 37 in command -insert into job_type(type_id, type_name) values ('JT2', 'Web Developer')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 38 in command -insert into job_type(type_id, type_name) values ('JT3', 'Maintenance')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 39 in command -insert into job_type(type_id, type_name) values ('JT4', 'Training')Error report -SQL Error: ORA-00001: unique constraint (ABM0721.SYS_C0024805) violated00001. 00000 - "unique constraint (%s.%s) violated"*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.*Action: Either remove the unique restriction or do not insert the key.Error starting at line : 42 in command -create table Staff(Staff_IDvarchar(10) primary key, Name varchar(50), Job_Type_idvarchar(5), Job_Grade integer,constraints_fk foreign key(job_type_id) references Job_type(type_id))Error report -SQL Error: ORA-00902: invalid datatype00902. 00000 - "invalid datatype"*Cause:
Oracle Database Assignment | DBMS_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Error report - SQL Error: ORA-00955: unique constraint (ABM0721.SYS_C0024374) virialization
|16
|7421
|159