DROP TABLE ASSETS
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
CREATE TABLE ASSETS (Asset_ID VARCHAR2(30), Item_Name VARCHAR2(240), Category VARCHAR2(30), Vendor NUMBER, Location_ID NUMBER, Unit_Price NUMBER, Quantity NUMBER, Parent_Or_Child VARCHAR2(30))
Table created.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('100.000', 'CPU', 'Hardware', 10001, 12345, 1000, 1,'Parent')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('100.100', 'Mouse', 'Hardware', 10001, 12345, 50, 2, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('100.100', 'Keyboard', 'Hardware', 10001, 12345, 100, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('100.100', 'OS', 'Software', 10001, 12345, 200, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('100.100', 'Assemble', 'Install', 10001, 12345, 150, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('100.100', 'Shipping', 'Freight', 10001, 12345, 100, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('101.000', 'Laptop', 'Hardware', 10002, 14567, 800, 1,'Parent')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('101.101', 'Mouse', 'Hardware', 10002, 14567, 50, 2, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('101.101', 'Keyboard', 'Hardware', 10002, 14567, 100, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('101.101', 'OS', 'Software', 10002, 14567, 200, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('102.000', 'CPU', 'Hardware', 10001, 12345, 1000, 1,'Parent')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('102.102', 'Mouse', 'Hardware', 10001, 12345, 50, 2, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('102.102', 'Keyboard', 'Hardware', 10001, 12345, 100, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('102.102', 'OS', 'Software', 10001, 12345, 200, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('102.102', 'Assemble', 'Install', 10001, 12345, 150, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('102.102', 'Shipping', 'Freight', 10001, 12345, 100, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('103.000', 'Laptop', 'Hardware', 10001, 12345, 1000, 1,'Parent')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('103.103', 'Mouse', 'Hardware', 10001, 12345, 50, 2, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('103.103', 'Keyboard', 'Hardware', 10001, 12345, 100, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('103.103', 'OS', 'Software', 10001, 12345, 200, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('103.103', 'Assemble', 'Install', 10001, 12345, 150, 1, 'Child')
1 row(s) inserted.
insert into Assets (Asset_ID, Item_Name, Category, Vendor, Location_ID, Unit_Price, Quantity, Parent_Or_Child) values ('103.103', 'Shipping', 'Freight', 10001, 12345, 100, 1, 'Child')
1 row(s) inserted.
COMMIT
Statement processed.