This Oracle SQL query keeps giving me errors and I can't seem to fix it. Please how and what to do to fix it? create tab

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

This Oracle SQL query keeps giving me errors and I can't seem to fix it. Please how and what to do to fix it? create tab

Post by answerhappygod »

This Oracle SQL query keeps giving me errors and I can't seem to
fix it. Please how and what to do to fix it?
create table Account
(
UserName varchar (15) primary key,
Password varchar(10) not null,
Phone number (10) not null,
Email varchar (30) not null
);
create table Region
(
RegionID varchar (15) primary key,
local varchar(10) not null,
WorldWide varchar(10) not null
);
create table Character
(
CharName varchar(10) primary key,
Lvl num(2) not null,
User_Name varchar(15) not null,
constraint fk_UN foreign key (User_Name) references Account
(UserName)
Type varchar(10) not null,
HP number (5) not null,
MP number (5) not null,
Region_ID varchar (15) not null,
constraint fk_RI foreign key (Region_ID) references Region
(RegionID)
);
create table Inventory
(
SpaceNum number(10) primary key,
Category varchar(15) not null
);
create table Item
(
ItemName varchar(10) primary key,
ItemType number(10) not null,
ItemDmg number(3) not null,
Space_Num number(10) not null,
constraint fk_SN foreign key (Space_Num) references Inventory
(SpaceNum)
);
create table Map
(
MapID number(10) primary key
);
create table pet
(
petName varchar(10) not null,
PetHP number(3) not null,
attack number(2) not null,
Map_ID number(10) not null,
constraint fk_MI foreign key (Map_ID) references Map (MapID)
);
desc Account;
desc Character;
desc Region;
desc Inventory;
desc Item;
desc Map;
desc pet;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply